Forum Discussion
7 day moving average - DAX error
Hi Experts
not if the folling is correct
7 Day Rolling Average =
CALCULATE(AVERAGE('ce DemandDestructionSimple'[Value]),
DATESINPERIOD(DimDate[Date],LASTDATE(DimDate[Date]),-7,DAY))
Check out this article by SQLBI:
https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/
1 Reply
Check out this article by SQLBI:
https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/