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 + ...
LisaBureau You used CALCULATE. More specifically, you used CALCULATE in a single table data model. Better Running Total - Microsoft Fabric Community
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)
RETURN
SUMX(_Table,[USD])