Notifications
Clear all
Dashboards & Charts
2
Posts
2
Users
0
Reactions
109
Views
Topic starter
I'm trying to create a dashboard in Power BI. I have 10 years of data in monthly resolution. I have a calculated moving average measure for each month. How would I calculate the average of that measure across the years for the same month? E.g. average of moving averages for December.
Thank you!
Posted : 11/06/2021 1:00 pm
Hi Rita,
You might be able to do it if you turn the measure you have into a calculated column, then use SAMEPERIODLASTYEAR to show the current month compared to same month last year.
Posted : 26/06/2021 1:47 am
