Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help in creating Data Delay Period Measure and Visualization T+1, T+2, T+3!!!!

Hi Experts, i need help in creating a visual similar to the one below. However, for Column 6 i've created a custom table and used a Switch function To bring in the Total Sales. The issue is the re...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , for moving avg, Create a date using month year and join with date table and measure like

 

example

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

 

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