Need Max value month wise from last 2 years selected from the slicer

[Anonymous]

Hi All,

I want maximum Value in each month from last 2 year comparison. Kindly help me if data is like below 

[Daniel29195 · Accepted solution]

@Anonymous 

write the following measure : 

(this will take into consideration current year and previous year ) 

m = 

var currentyear = year ( today() )

var ds = 

filter ( 

tbl_name ,  year >= currentyear -  1 )

RETURN

maxx( ds , value ) 

NB: if you want to take only prev 2 years excluding the current year,  change the filter to this : 

var ds = 

filter ( 

tbl_name ,  year >= currentyear -  2 && year < currentyear )

tbl_name being the table containing your data, and value being the column name with the values you want to display .

hope this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Anonymous]

hank kyou so much @Kishore_KVN  for the help

[Kishore_KVN · Accepted solution]

Hello @Anonymous please create below measure

Max Value = CALCULATE(MAXX('Table','Table'[Value]),ALLEXCEPT('Table','Table'[Month]))

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Daniel29195 · Accepted solution]

@Anonymous 

write the following measure : 

(this will take into consideration current year and previous year ) 

m = 

var currentyear = year ( today() )

var ds = 

filter ( 

tbl_name ,  year >= currentyear -  1 )

RETURN

maxx( ds , value ) 

NB: if you want to take only prev 2 years excluding the current year,  change the filter to this : 

var ds = 

filter ( 

tbl_name ,  year >= currentyear -  2 && year < currentyear )

tbl_name being the table containing your data, and value being the column name with the values you want to display .

hope this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Anonymous]

thanks @Daniel29195 , it also working for me.