Forum Discussion
Anonymous
3 years agoNot applicable
Rolling Total not calculating correctly
Hello all,
I have an issue where I am trying to calculate the rolling sum for monthly actuals
Actuals Month running total in FY Date =
CALCULATE(
SUM('iFiscal Unpivoted'[Actuals Month]),
FILTER(
ALLSELECTED('iFiscal Unpivoted'[FY Date]),
ISONORAFTER('iFiscal Unpivoted'[FY Date], MAX('iFiscal Unpivoted'[FY Date]), DESC)
)
)
The following screenshot illustrates my issue.
Here is what the data looks like in my model. Please note that some Actuals have repeated dates as they correspond with different expenses.
Can someone please help me find the right configuration to correctly calculate the rolling sum?
4 Replies
- Greg_Deckler
Community Champion
- AnonymousNot applicable
Thank you for the reply. It has fixed the sum for some of my data but sometimes I am running into this:
Any idea how this might have happened?
- Greg_Deckler
Community Champion
Anonymous Extremely hard to say without the data.