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

Cliff09's avatar
Cliff09
Regular Visitor
8 years ago

Yes, I have created it as a measure.

 

Here is the result I get on the sample data:

SivaMani's avatar
SivaMani
Resident Rockstar
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

  • Cliff09's avatar
    Cliff09
    Regular Visitor
    8 years ago

    Hi SaviMani,

     

    Thanks that did the trick. Although leaving it as AVERAGEX gives me that result I am after.

     

    I do run a "Can't display the vidual." error when I try to apply date slice to the page and I have sent off a 'frown' to Microsoft support for this.

     

    Thanks for your help!

     

     

  • GlassShark1's avatar
    GlassShark1
    Helper III
    5 years ago

    This is what i need thanks. Trying to get this to ignore an external slicer for geography though - i'm guessing i'm missing and ALL somewhere or something?