i have made a calculation to get monthly changes, so it is calculating this months values against previouw months values. The outcome for this calculation is working properly, so the values in column Actual are as expected.
But when I want to use these values into a YTD calculation, it is not working for some of the rows in the template.
I just don’t understand why the YTD totals are incorrect for some of them.
This is the DAX measure to get the monthly actuals:
Debiteuren = [Debiteuren Balans] - CALCULATE([Debiteuren Balans], PREVIOUSMONTH(dim_Calendar[Date])) *-1
and this for the YTD:
Debiteuren YTD =
CALCULATE([Debiteuren] , DATESYTD(dim_Calendar[Date]))
As you can see in attached printscreen, the actuals for “Debiteuren” should give a total of (-679984 + 275994 + 96549 + 43055 = ) -264386, but is is giving -944774.
For “Voorraden” the calculations are based on the same method and this one is okay. But for Crediteuren I also have issues with the YTD.
It is quit difficult to add the original report as there is a lot of other data in this report which I can not share. But I have attached a printscreen and hope somebody can point me into the right direction to get this solved.
Thanks for your help.