Forum Discussion
ngomes
Helper II
Helper IIPREVIOUSMONTH 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 valu...
some_bih
Community Champion
Community ChampionHi 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?
ngomesin 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