Hi,
I have a power query qryTotalSales that simply has SalesAgentID and SalesVolume as an aggregate
In another power query qryThreshold I have restricted it to a single value that I need to use as a threshold
I want to insert the threshold value into every row in qryTotalSales so that I get an output of
so that I can then apply a custom true/false column with the function [SalesVolume] >= [MinThreshold] which, if true, will then waive their agent fees for the month.
I can't do this with query merge since there is no matching fields to create a join. In Access, since these are small tables, I'd normally just do a DMax to retrieve the value '30' from qryThreshold. Any idea how to do this in Power Query? (still learning)
Cheers
I have a power query qryTotalSales that simply has SalesAgentID and SalesVolume as an aggregate
Code:
SalesAgentID SalesVolume
1 27
2 4
3 72
4 11
In another power query qryThreshold I have restricted it to a single value that I need to use as a threshold
Code:
MinThreshold
30
I want to insert the threshold value into every row in qryTotalSales so that I get an output of
Code:
SalesAgentID SalesVolume MinThreshold
1 27 30
2 4 30
3 72 30
4 11 30
so that I can then apply a custom true/false column with the function [SalesVolume] >= [MinThreshold] which, if true, will then waive their agent fees for the month.
I can't do this with query merge since there is no matching fields to create a join. In Access, since these are small tables, I'd normally just do a DMax to retrieve the value '30' from qryThreshold. Any idea how to do this in Power Query? (still learning)
Cheers
Last edited: