Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Rolling Average DAX to plot correctly on Column Chart

Hi All,   I have a problem with the measure of the 3mth rolling average to visualise it correctly on the graph.  The data model is here:  https://docs.google.com/spreadsheets/d/1naChcuZtjSbk0pVEi...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    Based on my test, we can take the following steps to meet your requirement.

     

    1. Enter the sample data as you shared and create a Calendar table using the formula.

     

    Calendar = CALENDARAUTO()

    2. Create the measure to achieve your goal.

     

    Measure = CALCULATE(SUM('Table'[Product A unaccum]),DATESINPERIOD('Calendar'[Date],MAX('Calendar'[Date]),-3,MONTH))/3

     

    For more details, please check the pbix as attached.

     

    Regards,

    Frank

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous,

 

Based on my test, we can take the following steps to meet your requirement.

 

1. Enter the sample data as you shared and create a Calendar table using the formula.

 

Calendar = CALENDARAUTO()

2. Create the measure to achieve your goal.

 

Measure = CALCULATE(SUM('Table'[Product A unaccum]),DATESINPERIOD('Calendar'[Date],MAX('Calendar'[Date]),-3,MONTH))/3

 

For more details, please check the pbix as attached.

 

Regards,

Frank

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case.

 

Regards,
Frank