Selected Month & Year Dax

[Anonymous]

Hello,

I am trying to write a Dax to show the selected year. But when no year is selected in the slicer, I want to the title to show the Max value of the date.

I worte: 

12m leading to = "12 months leading to "&SELECTEDVALUE(Dates[Year Month], (MAX(Dates[Year Month])))

However, this shows May 22 as the Max, because the max is based on alphebetical order.  I do have a Data table (please see below) which is created by Dax (Copied from Youtube 😅).  How could I show Aug 22 as the Max by changing the Dax above, please.

Thank you very much

Dates =

VAR Days = CALENDAR(Min('Service'[Date]), Max ('Service'[Date]))

Return ADDCOLUMNS(

Days,

"Year", YEAR([Date]),

"Month Number", MONTH( [Date]),

"Month", FORMAT ([Date], "mmmm"),

"Year Month Number", Year ([Date])* 12 + MONTH( [Date]) -1,

"Year Month", FORMAT([Date], "mmm yy"), "DateKey", FORMAT([Date], "yyyymmdd"

))

[Anonymous]

Thanks @amitchandak This worked! Now my title changes dynamically

[amitchandak]

@Anonymous , use in place of

SELECTEDVALUE(Dates[Year Month], (MAX(Dates[Year Month])))

Use this

maxx(filter(Dates, Dates[Date] = maxx(allselected(dates), Dates[Dates]) ), dates[year month])

or

maxx(filter(allselected(dates), Dates[Date] = maxx(allselected(dates), Dates[Dates]) ), dates[year month])

[Anonymous]

Thanks @amitchandak for your reply.  I tried both Dax measures, but I get an error message from both.  Am I doing anything wrong?

Thanks

[amitchandak · Accepted solution]

@Anonymous , Please check parenthesis position in your measure

try like

meausre =
var _max = maxx(allselected(dates), Dates[Dates])
return
maxx(filter(Dates, Dates[Date] =_max), dates[year month])