Calculated Measure

[CJ_96601]

Need help, 

Please see below sample table:  

Need to get the average by getting 2021  YE of 50 + data from 2022 based on month selected.

Note that 2021 YE must always be the YE total and must not be affected by date filters.

2021	Jan	2
2021	Feb	2
2021	Mar	2
2021	Apr	4
2021	May	5
2021	Jun	6
2021	Jul	7
2021	Aug	8
2021	Sep	8
2021	Oct	2
2021	Nov	2
2021	Dec	2
	Total YE	50
			Avg Formula - Total YE +  data (based on month selected)
2022	Jan	2	26
2022	Feb	3	26.5
2022	Mar	4	27
2022	Apr	5	27.5
2022	May	6	28
2022	Jun	7	28.5
2022	Jul	8	29

Thanks and regards, 

[amitchandak]

@CJ_96601 , Using a separate date/year table joined to you tbale

Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

Not you can have

Last Year = (CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1)) + sum('Table'[Qty]) )/2