Forum Discussion
Running total with no Month value
Hello,
I use the following formula for a calculation. This works fine, but if a Month has no Saldo the formula gives the sum of all the Months instead of the last 12 Month's. Do you know a solution?
CALCULATE(SUM(Grootboekrekeningensaldos[Saldo cumulatief ]);
DATESBETWEEN(Grootboekrekeningensaldos[Periode];
DATEADD(LASTDATE(Grootboekrekeningensaldos[Periode]);-11;MONTH);
LASTDATE(Grootboekrekeningensaldos[Periode])
)
)
Kind regards,
Mandy Pigmans
2 Replies
- amitchandak
Super User
ManPi ,Can you share sample data and sample output in table format?
v-lili6-msftCommunity Support
hi ManPi
First, for your case, you are using Time-intelligence function,
I would suggest you add a dim date table
http://radacad.com/do-you-need-a-date-dimension
Instead of use the date field in the fact table
and if you still have the problem, please share your sampel pbix file for us have a test.
Regards,
Lin
