Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
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!
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
Just updated to link from OneDrive to Dropbox. Could you please try now?
Thanks
rszirmai
Thank you so much for explaining the missing bit to me!
I have to think if I need an IF statement to prioritise one of the pricelist or just go with the MIN as it is within the current file.
Hi Pravin,
Can you access the pbix file attached to my question?
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
19 | |
19 | |
15 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |