Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have an issue where we have item sales which are calculated by quantity x current price. The difficulty is that our item prices changes few times a year as seen in screen shot.
For example if posting date is 30.6. the price for item 5230 should be calculated with price 9,32 and the next day it should be 9,45
Could you help me to write DAX where Power BI could use a valid price
Thank you for all the help beforehand 🙂
BR
Matti
Solved! Go to Solution.
Prices will change in about few weeks, right now I have manually filtered to use prices which have starting date before 1.7. If I don't do that, there will be double prices (1.4-30.6. & 1.7.-31.12.)
I have 2 data sources, Item Entries (Quantity) and Purchase Prices (Unit Cost EUR).
you posted other data above
Share sample pbix file to help you.
Hi
I couldn't attach any files but I hope this clears some more 🙂
Report should pick the correct purchase price what is used as posting date in item entries.
br
Matt
Your prices for today (14.06.2023) will be the: