Forum Discussion

nic2023's avatar
nic2023
Frequent Visitor
1 year ago
Solved

Remove duplicates based on conditions in Power Query

Hi everyone, I'm trying to remove some duplicates in a large list, which is formed from appending 2 lists of staff IDs. Some of the Staff IDs have duplicate entries, I'd like to set up some conditio...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    Hi,

    One of ways is using Table.Group function in Power Query Editor.

     

    let
    Source = Data_Source,
    #"Grouped Rows" = Table.Group(Source, {"Staff ID"}, {{"End Date", each List.Max([End Date]), type nullable date}})
in
    #"Grouped Rows"

     

     

nic2023's avatar
nic2023
Frequent Visitor
1 year ago

Sorry I'm using Power Query in Excel. 

Jihwan_Kim's avatar
Jihwan_Kim
Super User
1 year ago

Hi,

One of ways is using Table.Group function in Power Query Editor.

 

let
    Source = Data_Source,
    #"Grouped Rows" = Table.Group(Source, {"Staff ID"}, {{"End Date", each List.Max([End Date]), type nullable date}})
in
    #"Grouped Rows"