Forum Discussion

JustDavid's avatar
JustDavid
Icon for Helper V rankHelper V
2 years ago
Solved

Table.Group Dynamically Columns

Power Query Gurus,   I have a step below where I'm grouping all columns that has 'Column#' where # is a number from 2 onwards.       = Table.Group(Custom1, {"#"Remove Top Rows"}, { {"Column...
Need Help
Show and Tell
  • JustDavid's avatar
    JustDavid
    2 years ago

    Per Dino Tao's recommendation so as to mark this thread as solved.

     

    Table.Group(#"PreviousStep", {"Custom"}, 
   List.Transform(
      List.Difference(Table.ColumnNames(#"PreviousStep"), {"Custom"}), 
      (l)=> {l, each List.Sum(Table.Column(_, l)), type number}
   )
)

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi JustDavid ,

I'm glad you found a solution!
I suggest you revert with a new reply below with your answer and mark it as a solution, as posts that have been solved will be easier for other users to find, and perhaps you can help more users who are facing the same problem, thank you!

Best Regards,
Dino Tao