Forum Discussion

AndreOlha's avatar
AndreOlha
Frequent Visitor
3 years ago

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!    
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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