Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good morning, I need your help with a dax formula
I have a dax measure that calculates the difference between the predicted value and the realized value
and I would like to add the negative values from the previous month to add to the predicted value of the month
Can anyone help me with this formula?
Solved! Go to Solution.
Hi @ngomes
Check v2 and part YTD.
Proud to be a Super User!
Hi @ngomes in your model, all inputs are on monthly level, both Excpected and billing?
It seems you need to calculate per customer and per month TOTAL Year to date difference, and also per month monthly?
Proud to be a Super User!
in your model, all inputs are on monthly level, both Excpected and billing?
R: Yes, I have the calendar table linked with sales and expected values
It seems you need to calculate per customer and per month TOTAL Year to date difference, and also per month monthly?
R: I need to calculate the negative value from the current year and the previous month so that later I can add it to the expected value of the current month
Hi @ngomes
Check v2 and part YTD.
Proud to be a Super User!
Hi @ngomes more details needed about measures and model to provide possible solutions. On adding negative value/s is it according rule/s or fixed amount...
Proud to be a Super User!
Knowing that in January customer A had a realized value of -€536,588.56, I want to add this value to the expected value for the month of February.
the monthly objective would be €2,181,818.18 + €536,588.56
thanks for any help you can give me
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |