DAX - Group by last comment date of person

[Anonymous]

Hello, I'm struggling with something probably very simple...

I have the following table:

I want to keep the latest comment for each person like shown below. 2 comments at the same date for the same person cannot happen with my data.

Any help?

[BKirsch12 · Accepted solution]

This requires a little work to get the appropriate comment on the last date.

I did this in power query in excel for ease of use, but it works the same in Power BI.

First you need to create a comment date key. (Key query in the workbook)

This will allow us to do an inner join to get the appropriate comment.

Then you create a seperate query to do the group by. Group by person and add the max date. Then you add the two to make a key and join the two tables. 

All of the logic is in the file below:

https://drive.google.com/file/d/1dVtK64rrc9HzzK9WNFLE-LR5UCHBrnh5/view?usp=sharing