topic Get latest date from one column based on a value from another column. in DAX Commands and Tips

Get latest date from one column based on a value from another column.

L_K_ — Thu, 23 Feb 2023 12:10:43 GMT

Hello,

I need some help to get the latest date from one column based on a value from another column.

let's say I have a table like this:

Now I need to make a measure or filter or something that will single out the latest date (DATE_1) for every person (ID_NAME).

My table/visual would then look like this:

How can I achieve this? Please and thank you!

Kind regards,

amitchandak — Thu, 23 Feb 2023 15:15:10 GMT

L_K_ , Try if these logics can help

L_K_ — Fri, 24 Feb 2023 11:10:15 GMT

Thank you so much amitchandak !