Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Cumulative Total for a Summarize Table

Hello Experts,   Need help in getting running/Cumulative total. I have a summarized table and for that i need one more column that helps in getting cumulative total please help     SUMMARIZE (...
Need Help
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

try smth like

Measure =
var _curDate = MAX(Table[Date])
RETURN
CALCULATE(
SUM(Table[Results]),
FILTER(ALL(Table), Table[Date] <= _curDate )
)