Forum Discussion
Moving or Rolling Average KPI
Dear comunity friends. I am trying to create a saving KPI for a procurement department in power BI based on a moving average of the cost paid for the items. To reach this goal I did use the belo...
Anonymous ,
YTD Avg = CALCULATE(AvergaeX(Values('Date'[Month Year]), CALCULATE(SUM(Sales[Sales Amount]))),DATESYTD('Date'[Date],"12/31"))
next YTD Avg = CALCULATE(AvergaeX(Values('Date'[Month Year]), CALCULATE(SUM(Sales[Sales Amount]))),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
Hello Amit. Thanks for your prompt help. I'll adapt your formula to my data and I'll let you know the results.
Thanks again.