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

jmf2244's avatar
jmf2244
New Member
7 years ago

Thanks Anonymous . However, I am getting the following error: "A single value for column 'Revenue' in table 'xxxx' cannot be determined." (I replaced "Revenue" and "xxxx" with the real names to follow your example)

It seems like IF needs a single value in the logical test, not a table, right?