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 (of the total column numbers) for the last three months. So June's three month trailing average would be $42,643,068. I tried creating measures that would use average and sum fucntions but I can't use the Sum function with the average function in a measure.
I each month was its own table that I appended into one. here are my current fields
5 Replies
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
Hi,
Share the download link of the PBI file.
I think I did this right. Uploaded to the service then copied the link. I am not sure if the settings are correct for others to view though.
That takes me to a sign-in page.
I will give this a try! Thank you!
