Forum Discussion

Anon29's avatar
Anon29
Helper II
2 years ago
Solved

Group By - updated problem

Hi all, hoping someone can help. The data below is an example of one phone conversation and the order of the people talking is in order from first contact person being 411 to the last contact person...
Need Help
Show and Tell
  • mlsx4's avatar
    mlsx4
    2 years ago

    Hi Anon29 

     

    I think you can reach this behaviour in Power Query using Group by like in the screenshot below:

     

     

  • AlienSx's avatar
    AlienSx
    2 years ago

    Hi, Anon29 looks like you need to select min Talkorder withing each Talk ID and Name.

    let
    Source = raw_data_table,
    group = Table.Group(Source, {"Name", "Talk ID"}, {{"all", each Table.Min(_, "Talkorder")}}),
    expand = Table.ExpandRecordColumn(group, "all", {"Date", "Talkorder"})
in
    expand

Anon29's avatar
Anon29
Helper II
2 years ago

Thanks everyone, looks like I gave the wrong data, but the solutions you have given me is correct for the data that I have.