Latest date based on multiple columns

[lilych]

Hello -

I have a table (see below) where updates are being entered. I only want to show the latest Created On Date based on the Department and Product columns. So for Marketing + Category A's update, I only want the 2nd bolded update to show, since it is the latest update for that department and product.

How would I go about doing this? Thanks in advance!

Department	Product Line	Update	Created On
Marketing	Category A	Version 1 update	6/16/21 8:01 AM
Marketing	Category A	Version 2 update	6/16/21 10:21 AM
Marketing	Category B	Version 1 update	6/16/21 2:00 PM
Sales	Category A	Update	6/16/21 9:36 AM

[v-henryk-mstf · Accepted solution]

Hi @lilych ,

I did a test, the reference is as follows:

M_update =
VAR _max =
    CALCULATE (
        MAX ( 'Table'[Created On] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Product Line] = MAX ( 'Table'[Product Line] )
                && 'Table'[Department ] = MAX ( 'Table'[Department ] )
        )
    )
RETURN
    CALCULATE ( MAX ( 'Table'[Update] ), 'Table'[Created On] = _max )

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[notem]

@lilych ,

Measure = 
VAR a = MAX(Sheet1[Created On]) 
RETURN 
    CALCULATE(MAX(Sheet1[Line Update]), Sheet1[Created On] = a)