cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III

## How to get the latest date value from the column

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

1 ACCEPTED SOLUTION
Community Champion

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

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

3 REPLIES 3
Community Champion

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

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

Resolver III
Table 2 =
SUMMARIZE( 'Table',

'Table'[ Name],
"__MaxDate_Checke_Out",
CALCULATE (
MAX ('Table'[Date Checked Out]),
REMOVEFILTERS ( 'Table'[Date Checked Out])),"User",CALCULATE(MAX('Table'[      User]),'Table'[Date Checked Out]=MAX ('Table'[Date Checked Out])
))
could you please try the summarize concept and let me know if it's solved your need.
Super User

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

Latest =
IF(
CALCULATE(MAX(checkOutTable[Date Checked Out]),ALLEXCEPT(checkOutTable,checkOutTable[Name])) = [Date Checked Out],
"Latest",
"Not Latest"
)

Then use that column in as criteria in a measure

Latest Check Out Date =
CALCULATE(
MAX(checkOutTable[Date Checked Out]),
checkOutTable[Latest] = "Latest"
)

You should end up with

Proud to be a Super User!

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors