Finding a value related to latest Date

[Anonymous]

Hi all,

I have a table with these columns:

Name and Date Obs

I want to add a third column (Latest Obs Date). Latest Obs Date looks at all rows with the same Name, finds the latest Date out of all those rows, and gives me the date from that row. See example in the table below:

Name	Date Obs	Latest Obs Date
Abraham Lincoln	8/1/2019	8/1/2019
Bill Gates	8/5/2019	9/2/2019
Bill Gates	9/2/2019	9/2/2019
Gandhi	8/9/2019	9/3/2019
Gandhi	9/3/2019	9/3/2019
John F. Kennedy	9/2/2019	9/2/2019
John F. Kennedy	8/14/2019	9/2/2019
Marilyn Monroe	9/11/2019	9/11/2019

Thanks in advance for the help

[Anonymous]

I have a table with these columns:

Name and Date Obs

I want to add a third column (Latest Obs Date). Latest Obs Date looks at all rows with the same Name, finds the latest Date out of all those rows, and gives me the date from that row. See example in the table below:

Name	Date Obs	Latest Obs Date
Abraham Lincoln	8/1/2019	8/1/2019
Bill Gates	8/5/2019	9/2/2019
Bill Gates	9/2/2019	9/2/2019
Gandhi	8/9/2019	9/3/2019
Gandhi	9/3/2019	9/3/2019
John F. Kennedy	9/2/2019	9/2/2019
John F. Kennedy	8/14/2019	9/2/2019
Marilyn Monroe	9/11/2019	9/11/2019

Thanks in advance for the help

[amitchandak · Accepted solution]

Check

https://community.powerbi.com/t5/Desktop/How-to-find-latest-date-value-in-a-group/td-p/379104

https://community.powerbi.com/t5/Desktop/Return-Latest-Date/td-p/417291

[Anonymous]

Thanks @amitchandak,

I'm working with tables that I need to join based on this calculated field. I know how to do the calculation in DAX, however, this doesn't help me merge the tables (I need to join on multiple columns so relationships won't work). I know if I can get the DAX function I used in DAX into Power Query I will be able to merge the tables but I just can't quite get the formula right. This is what I have in DAX:

Latest Obs Date = CALCULATE ( LASTDATE ( 'Tutor Observation Log'[Date Obs] ), ALLEXCEPT ( 'Tutor Observation Log' , 'Tutor Observation Log'[Name] ) )

Any help is appreciated!!