Forum Discussion
Trailing Average HELP
I have a built a table that shows the weighted net fee by studio for the last three months. I would like to find a way to also have a visualization for each month that would show the Average (...
bscholler , You can three month Avg of your measure free - Weight Free
3 Month Avg = CALCULATE(AverageX(Values('Date'[MONTH Year]),[Weight free])
,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))
If you only need it in Subtotal/grand total use isinscope
How to Switch Subtotal and Grand Total in Power BI | Power BI Tutorials: https://youtu.be/smhIPw3OkKA