DAX measure for Max Date

[pfarahani]

Hello, 

I am creating a measure to get the max month and the max year that is in my data. So far I have a working measure that gets the latest month. Can I also add the Year to this? How can I add another variable and be able to use it for my year column. Thanks

Max Word =

VAR MaxOrder =

MAX ( 'Dates TEST'[MonthNum] )

RETURN

CALCULATE ( MAX( 'Dates TEST'[Month] ), 'Dates TEST'[MonthNum] = MaxOrder )

[selimovd]

Hey @pfarahani ,

your measure takes the MAX MonthNum. So if you want to get the MAX year, you have to do the same with the column that contains the year. Or with date and get the year out of that date.

But I don't know your data, so you either have to find our yourself or share some more information.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[pfarahani · Accepted solution]

I think I got it, check this one out:

Latest Date =

VAR MaxOrder =

MAX ( 'Dates TEST'[MonthNum] )

VAR MaxYear =

MAX('Dates TEST'[Year])

RETURN

CALCULATE ( MAX( 'Dates TEST'[Month] ), 'Dates TEST'[MonthNum] = MaxOrder ) & " " & MaxYear