Plot the Average line for range 2023 to 2018

[Anonymous]

Hi Experts

I am trying to plot the average / mean line for the last 5 years from 2023 to 2018, my measures are in Data table. Measure name 2018-2023 mean

I would expect to see mean average values in the 150K range but i am getting 1000 range.

Sample File

https://www.dropbox.com/s/o0mx4mgq5kgm6zf/Test%20%281%29.pbix?dl=0  

[Anonymous]

Thanks Amit can you kindlyly delete the PBIX from the question

[amitchandak · Accepted solution]

@Anonymous , Try a measure like for line. File is attached after signature

Measure = var _max = maxx(ALLSELECTED(DimDate), DimDate[Year])
var _min1 = Minx(ALLSELECTED(DimDate), DimDate[Year])
var _min = _max -5
return if(max(DimDate[Year]) =_max, calculate(
AVERAGEX('DimDate', CALCULATE(SUM('Date'[monthly_kbd]))), FILTER(all('DimDate'), 'DimDate'[Year]>=_min && 'DimDate'[Year]<=_max  )), BLANK())