Identify the latest date in a date column and return specific value

[Anonymous]

Hi,

I'd like to add a column to my table that will identify if the result in column [MonthStart] is the latest date.  Here is an example of my data table:

I'd like to add this column to the right.  Essentially, if the date in column [MonthStart] is the latest return "Latest", if not then return "Not the Latest".

The MonthStart column is already formatted as a date data type:  (mmmm yyyy)

an you assist me in the DAX?

Thank you,

Andrew

[Anonymous · Accepted solution]

Hi @Anonymous,

Did you mean to check the current date if it is the last one of the current category?

If that is the case, please take a look at the following formula if helps:

Calcualte column =
VAR temp =
    ADDCOLUMNS (
        CALCULATETABLE (
            VALUES ( Table[Month Start] ),
            FILTER ( Table, [Car Make] = EARLIER ( Table[Car Make] ) )
        ),
        "Date", DATEVALUE ( "1 " & [Month Start] )
    )
RETURN
    IF (
        Table[Month Start] = FORMAT ( MAXX ( temp, [Date] ), "MMM yyyy" ),
        "Latest",
        "Not the Latest"
    )

Regards,

Xiaoxin Sheng

[Anonymous]

hi @Anonymous 

Try this

_Latest_Flag = if(('Table'[MonthStart] = FORMAT(NOW(),"mmmm yy")),"Latest","Not Latest")

Thanks!

PS: Please accept the post if you agree with solution!