Shadow chart - Total per month and then min max

[viltxes14]

Hi, I think this might be easy: 

I need a chart showing the current year monthly total and I want to have a "shadow" part in the chart showing the max and min of the last 5 years to see how this year is going. 

So I think I need to calculate the total per month and then the 5 year max and min for each month of the year but I cannot figure out the measure. 

thanks!

[amitchandak · Accepted solution]

@viltxes14 , refer if this can help

minx(summarize(Table,Table[Month-Year],"_1",sum(Table[Value])),[_1])

maxx(summarize(Table,Table[Month-Year],"_1",sum(Table[Value])),[_1])

[viltxes14]

Hi Amit, 

It works fine with the total per month. Do you know how can I do it if I need the daily average per month?

thanks a lot, 

kind regards, 

[viltxes14]

Thanks! it works perfect!!!