Forum Discussion

rsbin's avatar
rsbin
Community Champion
3 years ago
Solved

Power Query: Keep MaxDateTime by Group

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,

  • 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.

1 Reply

  • rsbin's avatar
    rsbin
    Community Champion

    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.