Trailing Average HELP

[bscholler]

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

[bscholler]

I will give this a try!   Thank you!

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Ashish_Mathur]

That takes me to a sign-in page.

[bscholler]

https://app.powerbi.com/links/66Bn3J4rT8?ctid=89c36a4c-ae54-4b3f-90b1-b13e3b389e56&pbi_source=linkSh...

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. 

[amitchandak]

@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