Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have following table and I need the repeated row with latest date. I need only those values which was signed latest
Name | User | Date Checked Out | ||
ABC | OOO | 2017-12-14T11:47:00 | ||
ABC | XXX | 2017-12-14T11:57:00 | ||
ABC | HHH | 2017-12-14T11:17:00 | ||
DEF | VAA | 2017-12-17T11:47:00 | ||
DEF | KAS | 2017-12-17T11:00:00 |
Here I need result like below:
ABC | XXX | 2017-12-14T11:57:00 | |
DEF | VAA | 2017-12-17T11:47:00 |
Can someone please help?
Solved! Go to Solution.
Try:
Latest date by name =
VAR _LatestDate = CALCULATE(MAX(Table[Date Checked out]), ALLEXCEPT (Table, Table[Name]))
RETURN
COUNTROWS (SUMMARIZE (FILTER(Table, Table[Date Checked out] = _LatestDate), Table[Name], Table[User, Table[Date Checked Out])
add the three fields to a table visual, add the [Latest date by name] measure to the filter pane and set the value to equals 1
Proud to be a Super User!
Paul on Linkedin.
Try:
Latest date by name =
VAR _LatestDate = CALCULATE(MAX(Table[Date Checked out]), ALLEXCEPT (Table, Table[Name]))
RETURN
COUNTROWS (SUMMARIZE (FILTER(Table, Table[Date Checked out] = _LatestDate), Table[Name], Table[User, Table[Date Checked Out])
add the three fields to a table visual, add the [Latest date by name] measure to the filter pane and set the value to equals 1
Proud to be a Super User!
Paul on Linkedin.
I am sure there are other ways to do this but you can add a column to your table that determines if the Date Checked Out is the lastest for that name
Proud to be a Super User! | |
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
150 | |
118 | |
111 | |
106 | |
95 |