Forum Discussion
PREVIOUSMONTH negative values
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?
7 Replies
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
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
