Forum Discussion

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
2 years ago
Hi Anon29

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

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