Forum Discussion

Cliff09's avatar
Cliff09
Regular Visitor
8 years ago
Solved

12 Month Rolling average.

Hi,   I have been asked to show our monthly sales with a moving average in a table (and chart). Here is some sample data:   Sale Date Sale Amount 2/07/2017 $15,000 11/07/2017 $20,000 ...
  • SivaMani's avatar
    SivaMani
    8 years ago

    Cliff09,

     

    Apologise for the late response. Addressed your issue.

     

    Here is the solution,

     

    Step 1: Create a quick measure -> Rolling average

     

     

    Step 2: Edit the DAX of the quick measure -> Change AVERAGEX to SUMX

     

    That's it

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hi, i have been using quick measures to calculate rolling average of the last 3,6,12 and 18 months to generate the rankings at work, for some odd reason the averages dont work anymore since we are in a new year, can someone help i am stuck

  • SivaMani's avatar
    SivaMani
    Resident Rockstar
    7 years ago

    Can you share more detail about your issue with sample data?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi SivaMani

       

      i have sent you a link to my pbix file via private message

       

      kind regards

      HiltonM