Forum Discussion
Tableau's Running Total But In Power BI
Hi, I followed this video to create a cumulative % in Power BI. The videos works correctly for my data because I have similar dataset to the one in the video. I have a categorical column (similar t...
Anonymous , Use window function
Cumm Based on Measure = CALCULATE([Your Measure], Window(1,ABS,0,REL, ALLSELECTED('Table'[State]),ORDERBY([Your Measure],Desc, 'Table'[State], asc)))
Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f
Anonymous , Use window function
Cumm Based on Measure = CALCULATE([Your Measure], Window(1,ABS,0,REL, ALLSELECTED('Table'[State]),ORDERBY([Your Measure],Desc, 'Table'[State], asc)))
Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f