Forum Discussion
Combine queries with conditions
I have two tables - one with order data and one with pricing data. I want to combine the pricing data query to the order data so I can pull in the new price against historical order data. Order ...
amitchandak
Super User
Super Userbobert523 , Create a new column in dax like
new column =
maxx(filter(price, price[Cust #] = order[Cust #] && price[Loc #] = order[Loc #]&& price[Item #] = order[Item #] && Price[Order minimum for price] <= Order[Order Qty]),Price[Order minimum for price] )
return
maxx(filter(price, price[Cust #] = order[Cust #] && price[Loc #] = order[Loc #]&& price[Item #] = order[Item #] && Price[Order minimum for price] = _max),Price[Price per unit] )
Hello- thank you for your suggestion. I tried that, but get "Token Literal expected" on the Pricing[Loc#] step.