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 from date.
Columns in `MyDate' table: `SalesDate` in mm/dd/yyyy formate, and `Month` with months name.
Here's the DAX i came up with to calulate 2 months of Rolling average:
How do I get the rolling average for each month?
Go to Solution.
Solved: CALCULATE([Measure],DATESINPERIOD( 'Date'[Date], MIN( 'Date'[Date] ) -1, -3, MONTH ))
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.