Combine queries with conditions

[bobert523]

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 Data-

Cust #

Loc #

Item #

Order Qty

Price Data-

Cust #

Loc #

Item #

Order minimum for price (same UOM as Order Qty in Order Data), but would use a <= 

Price per unit

Having an issue pulling in the correct price based on quantity.

[amitchandak]

@bobert523 , 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] )

[bobert523]

Hello- thank you for your suggestion.  I tried that, but get "Token Literal expected" on the Pricing[Loc#] step.