Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to create rolling average from a measure

I have a measure: 'Monthly sales count' This measure is calculated from `Monthly sales` table that has an established with `MyDate` table. `MyDate` table has a column Month to retrieve month name f...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Solved:  CALCULATE([Measure],DATESINPERIOD( 'Date'[Date], MIN( 'Date'[Date] ) -1, -3, MONTH ))

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Solved:  CALCULATE([Measure],DATESINPERIOD( 'Date'[Date], MIN( 'Date'[Date] ) -1, -3, MONTH ))