Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculating a rolling average for percentages

Hi, I’m very new to DAX so would appreciate any help on this one! I have Overall Satisfaction data measured on a scale of 1 (Very dissatisfied) to 7 (Very satisfied). I have bucketed this data by c...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous ,

 

You may research the code generated by Quick measure Rolling average.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for the suggestion about using a Quick Measure. I had tried that but got an error message 'Only Power BI - provided date hierarchies are supported' (although, using the same Date field in a Month over Month change measure worked.

     

    I found the following syntax on another discussion thread:

    OVERALL CSAT AVG_3MTH_MA =

    CALCULATE (

        AVERAGEX ( 'testdata', 'testdata'[Overall Sat] ),

        DATESINPERIOD (

            'DateKey'[Date],

            LASTDATE ( 'DateKey'[Date] ),

            -3,

            MONTH

        )

    )

     

    I've used this successfully to create a rolling 3-month average for the score but I can't create the rolling average for the percentage buckets (as described in my first post) correctly. I'm not sure of the syntax I should be using to filter the scores for each bucket. 

     

    I'd really appreciate any help on this one! TIA.