Forum Discussion

imranamikhan's avatar
imranamikhan
Icon for Helper V rankHelper V
6 years ago
Solved

Filter records by most Recent Time Stamp

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

 

Need Help
  • Icey's avatar
    Icey
    6 years ago

    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.

     

2 Replies

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    6 years ago

    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.