Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Rolling Average visualisation issue 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/1naChcuZtjSbk...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    Write this measure and drag it to your visual

     

    =CALCULATE(SUM('Table'[Product A uncum]);DATESINPERIOD('Table'[Date];LASTDATE('Table'[Date]);-3;MONTH))

     

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Write this measure and drag it to your visual

 

=CALCULATE(SUM('Table'[Product A uncum]);DATESINPERIOD('Table'[Date];LASTDATE('Table'[Date]);-3;MONTH))

 

Hope this helps.