Max Date by month and location

[blpaxson]

I need to identify which row of data was the last (END_DATE) in each month by IMPORT_CODE.  I would like to simply return on those rows the words "LAST" to allow me to use/filter the data for only those with the last data point.  End of Month and Days from last date I added but this seems inefficient.

[Anonymous · Accepted solution]

Hi @blpaxson ,

You can create two calculated columns as below to get it:

YearMonth = FORMAT('Table'[END_DATE],"YYYYMM")

Column =
VAR _maxdate =
    CALCULATE (
        MAX ( 'Table'[END_DATE] ),
        FILTER (
            'Table',
            'Table'[YearMonth] = EARLIER ( 'Table'[YearMonth] )
                && 'Table'[IMPORT_CODE] = EARLIER ( 'Table'[IMPORT_CODE] )
        )
    )
RETURN
    IF ( 'Table'[END_DATE] = _maxdate, "LAST" )

Best Regards

[amitchandak]

@blpaxson , Based on what I got these blogs should help

Latest Date
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...

Power BI Get the Last/Latest Value of a Category: https://www.youtube.com/watch?v=W4EF1f_k6iY