Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Rolling Count Formula

Hi all ,   I have this Rolling count formula for the previous 6 months. But the numbers dont match and I dont know why.   Sol Provided Cases 6MM = VAR pre6 =     CALCULATE(EOMONTH( MAX ( 'All...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Anonymous , I usually prefer to join the key date with date table and use columns from date table in visual, measure and slicer and formula like

 

Rolling 6 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-6,MONTH))

 

Rolling 6 = CALCULATE([Net], WINDOW(-5,REL, 0, REL, ADDCOLUMNS(ALLSELECTED('Date'[Month Year],'Date'[Month Year Sort] ),ORDERBY([Month Year Sort],asc)))

 

Rolling Months Formula: https://youtu.be/GS5O4G81fww

 

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