Forum Discussion
Solved
Cumulative Total - Confused
I am terribly confused. Below is a cut of my table including the Column created using this "formula":
***bleep*** Forecast = CALCULATE(SUM('Year Actual + Forecast'[USD]),FILTER(ALL('Year Actual + Forecast'),'Year Actual + Forecast'[Date]<= EARLIER('Year Actual + Forecast'[Date])))
As you can see, I am not getting the expected result - Dec total should be the $4,558...
What have I done wrong please?
(MS doesn't like the "Cumulative" abbreviation and changes it to bleep)
LisaBureau You used CALCULATE. More specifically, you used CALCULATE in a single table data model. Better Running Total - Microsoft Fabric Community
2 Replies
LisaBureau You used CALCULATE. More specifically, you used CALCULATE in a single table data model. Better Running Total - Microsoft Fabric Community
Greg_Deckler THANK YOU
Using this worked:
USD RT =VAR _Date = max('Year Actual + Forecast'[Date])VAR _Table = FILTER(ALLSELECTED('Year Actual + Forecast'),[Date]<=_Date)RETURNSUMX(_Table,[USD])
