Forum Discussion
3/5 Year Average
Hello,
How do I build a calculation where I get a 3/5 year average of (GJ) for each month?
Many thanks!
1 Reply
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
