Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@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] )
Hello- thank you for your suggestion. I tried that, but get "Token Literal expected" on the Pricing[Loc#] step.
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |