Forum Discussion

Renato_mon's avatar
Renato_mon
Frequent Visitor
3 years ago
Solved

Group by text and result only differences.

Hello,   I'd like to group by text and result only the differences between each grouped row. I appreciate the help! Thanks   The result I expect: Product market Part x1 AX2 ZZZ x2...
Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago

    Hi, Renato_mon 

    let
    Source = your_table,
    g = Table.Group(Source, "Part", {{"Count", each Table.RowCount(_)}, {"a", each _}}),
    flt = Table.SelectRows(g, each ([Count] = 1)),
    z = Table.Combine(flt[a])
in
    z
AlienSx's avatar
AlienSx
Super User
3 years ago

Hi, Renato_mon 

let
    Source = your_table,
    g = Table.Group(Source, "Part", {{"Count", each Table.RowCount(_)}, {"a", each _}}),
    flt = Table.SelectRows(g, each ([Count] = 1)),
    z = Table.Combine(flt[a])
in
    z