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 Power BI Community,
I'm calculating Estimated Inventory per Weeks and want to deduct a fixed value or a measure so it is reflected per weeks. Formula is: Inventory + Open Purchse Orders - Average Sales which should be fixed in each row in the table.
My measure is: sum('PO'Open PO)+[Iventory]-CALCULATE(sum(DimDate[Column]),ALLSELECTED(DimDate))
Is it the solution to create Avg Sales in DimDATE Table like I did so it is reflected on a week level given that now I cannot deduct Measure Average Sales.
Thank you
Nikola
Hi @nivanovic
Can you please explain it with example in a table and the expected output.
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |