Power Query: Keep MaxDateTime by Group

[rsbin]

Good Afternoon,

I have a scenario that I am not able to fully resolve in Power Query

I have the following simplified dataset:

ReportDate	ClientSiteDisplay	MaxDateTimeCT
3/9/2023	ABC	2023-03-09T09:15:03
3/12/2023	ABC	2023-03-12T06:02:10
3/12/2023	ABC	2023-03-13T02:00:58
3/9/2023	XYZ	2023-03-09T04:57:07
3/9/2023	XYZ	2023-03-09T07:57:14
3/12/2023	XYZ	2023-03-12T08:27:32

I want to keep only the MaxDate by Group where GroupBy = ReportDate & ClientSiteDisplay.

So final result should look like this:

ReportDate	ClientSiteDisplay	MaxDateTimeCT
3/9/2023	ABC	2023-03-09T09:15:03
3/12/2023	ABC	2023-03-13T02:00:58
3/9/2023	XYZ	2023-03-09T07:57:14
3/12/2023	XYZ	2023-03-12T08:27:32

As always, any and all guidance is much appreciated!

Regards,

[rsbin · Accepted solution]

Decided to perform the operation in DAX instead of Power Query.
In this way, User can see the Records in Error if they so choose.