Forum Discussion
Solved
Need help - Moving Average Formula ERROR
Hello, I am new to Power BI and DAX. I am trying to create a measure for calculating the moving average of 3 monthly sales by area on Power BI Desktop/Service. I have googled many websites but...
HI, just did one of these this morning for a 6 wk rolling average $/kg:
calculate(sum(Data[Operating]),DATESBETWEEN(Data[Week start],LASTDATE(Data[Week start])-42,FIRSTDATE(Data[Week start])))
/
calculate(sum(Data[kg]),DATESBETWEEN(Data[Week start],LASTDATE(Data[Week start])-42,FIRSTDATE(Data[Week start])))
desiree And dates in calendar table matches with dates in sales table ?
ankitpatira , yes.. I used pivottable to get the unique dates from Sales table to prepare Calendar table.
I had the same issue. I used this blog post and made changes to my DAX. It works perfectly. I do not remember what caused my issues but here is the link to the post:
http://www.powerpivotpro.com/2013/07/moving-averages-sums-etc/
