Forum Discussion

lilych's avatar
lilych
Helper II
5 years ago
Solved

Latest date based on multiple columns

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 LineUpdateCreated On
MarketingCategory AVersion 1 update6/16/21 8:01 AM 
MarketingCategory AVersion 2 update6/16/21 10:21 AM
Marketing Category BVersion 1 update6/16/21 2:00 PM
SalesCategory AUpdate6/16/21 9:36 AM
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    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.

2 Replies

  • notem's avatar
    notem
    Frequent Visitor
    5 years ago

    lilych ,

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

     

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    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.