pricing
1 Topic
DAX Pricing based on multiple criteria
Dear PBI Community, I would like to ask for some help with something that I cannot solve. We have 3 tables: 1. FACT from Vendor using Vendor's ID and Vendor's QTY/UnitOfMeasure 2. Items with the conversion factor and our unique ID 3. Pricing for our unique ID based on multiple criteria (dates, qty breaks) I am trying to "move" the correct Unit Price from Pricing table to FACT table (to calculate Sales). Please find attached my pbix file. (just 1 product for the sake of sharing) PBI_UnitPrice I tried to put multiple FILTER criteria into my calculation but for some reason (I guess) the qty break part is wrong. All help is much appreciated! ThanksSolved1.9KViews0likes7Comments