keep row based on a column for duplicate IDs in Power Query

[wes-shen-poal]

Hi there,

i have a data table with columns ServiceDirectionCode and DateTo

I would like this data table to give me all the different ServiceDirectionCodes, and for the duplicate codes, I only want to keep the row with the latest DateTo.

Is this possible to do in the Query Editor?

Thanks,

Wes

[Ashish_Mathur · Accepted solution]

Hi,

You may use the Group By feature and take the maximum of the DateTo column.

[v-sihou-msft · Accepted solution]

@wes-shen-poal

As @Ashish_Mathur suggsted, just have your records group on Code level with max aggregation on Date column.

Regards,

[wes-shen-poal]

Thanks @Ashish_Mathur@v-sihou-msft

Appreciate the help very much 🙂

Wes

[Ashish_Mathur · Accepted solution]

Hi,

You may use the Group By feature and take the maximum of the DateTo column.