Get last month form a measure

[Wresen]

Hi and thanks for reading this.

I want to get the max month number based on a measure.

Mesure 1 is doing calaculations and get the results as shown.

If i do MAX(month[month]) now i get 202205 
I would like the get the last month (202112) that has a number calculated.

This needs to be in a measure.

I hope i could explain what i want to do.

/Thanks 

[Deku · Accepted solution]

MAXX(

Filter(

Allselected( table[month]),

Not iSBLANK( [measure] )

),

Table[month]

)

[Wresen]

Thanks so much @Deku for the help.