Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Cumulative Running total

Hi All , I am kind of struck with this logic. Checked online forums. Did not get proper logic. Can anyone help on this getting    Date NetFlow **bleep** Net Flow Apr-23 -38 -38 May-23 -47 -85 Ju...
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , if you have date, with help from date table try like

 

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))

Cumm Based on Date = CALCULATE([Net], Window(1,ABS,0,REL, ALL('date'[date]),ORDERBY('Date'[date],ASC)))

Cumm Based on Date = CALCULATE([Net], Window(1,ABS,0,REL, ALLSELECTED('date'[date]),ORDERBY('Date'[date],ASC)))

 

 

Running Total/ Cumulative:
https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=42

 

Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc