Filter records by most Recent Time Stamp

[imranamikhan]

Hello,

I have a number of records with duplicates. Each record has a timestamp (date & time). I would like to display only the most recent record amongst the duplicates. Because the source data is a push dataset, I cannot use calculated columns. I understand I will need a DAX measure and then apply that measure to visual level filters.

If anyone could help with the DAX measure/s would be appreciated.

Sample File on OneDrive 

best regards,

ImranAmi

[Icey · Accepted solution]

Hi @imranamikhan ,

Please check if this could meet your requirments:

Measure =
VAR MostRencentTime =
    CALCULATE (
        MAX ( 'Table'[RecordTimeStamp] ),
        ALLEXCEPT ( 'Table', 'Table'[Task ID] )
    )
RETURN
    IF ( MostRencentTime = MAX ( 'Table'[RecordTimeStamp] ), 1, 0 )

Best Regards,

Icey

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

[imranamikhan]

Perfect. Many thanks @Icey