how to do month(max(date)) in DAX?

[Anonymous]

I have a visual where I just want to display the month of the latest date…

In sql I would do month(max(date))… In dax; I do max(month) and I obviusly get the wrong result…

How can achieve it?

(my model is pretty standard, with DimDate and a fact connected to it….

[amitchandak]

@Anonymous , Try measure like

Month(maxx(allselected(Table), Table[Date]))

or

format(maxx(allselected(Table), Table[Date]), "mmm")