3/5 Year Average

[AndreOlha]

Hello,

How do I build a calculation where I get a 3/5 year average of (GJ) for each month?

Many thanks!

[amitchandak]

@AndreOlha , You can create a measure like this with help from date table

Only year vs Year, not a level below

This Year = CALCULATE(AverageX(Values(Date[Month Year]), calculate(  sum('Table'[GJ]) )) ,filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s