Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
best regards,
ImranAmi
Solved! Go to 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.
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.
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |