Forum Discussion

desiree's avatar
desiree
Frequent Visitor
10 years ago
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...
Need Help
  • samdthompson's avatar
    samdthompson
    10 years ago

    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's avatar
desiree
Frequent Visitor
10 years ago

ankitpatira , I have already joined the dates in sales table and calendar table.... Do you have any other idea?

 

Thank you.

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

desiree And dates in calendar table matches with dates in sales table ?

  • desiree's avatar
    desiree
    Frequent Visitor
    10 years ago

    ankitpatira , yes.. I used pivottable to get the unique dates from Sales table to prepare Calendar table.