Forum Discussion
Help with Running Total
I've reviewed several posts and this seems mostly the same as Solved: Re: DAX Question: Running Totals with Missing Valu... - Microsoft Fabric Community, but I can't seem to understand the formula we...
CmdrKeene , have separate hour column and hour table and have measure like
Cumm Hour= CALCULATE(SUM(Sales[Amount]),filter(all('Hour'),'Hour'[Hour] <=max('Hour'[Hour])))
Cumm Based on Hour= CALCULATE(SUM(Sales[Amount]), Window(1,ABS,0,REL, ALL('Hour'[Hour]),ORDERBY('Hour'[Hour],ASC)))
or you try cumulative with window with partition by
Continue to explore 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