Grouping by a list of columns

[Shachar_Tal]

Hi,

I have a table that contains about 50 columns.... Some columns are parameters and some are plain text.

I'm trying to avoid selecting all aggregating columns manually so I need a way to dynamically group the table in a way that the aggregated columns are those given in a different list.

Any ideas??

Thanks

[latimeria]

Table.SelectColumns(table, listofcolumns).
You can get the list of columns by using Table.ColumnNames(table) to avoid misspelling

[Shachar_Tal]

Hi,

Thanks for your response.

This method will only provide the table with the selected columns... The question is how do I group by these columns while aggregating all other columns?

[Jakinta · Accepted solution]

There is a similar thread. Maybe it can help.

https://community.powerbi.com/t5/Power-Query/Table-Group-possible-to-group-except-certain-columns/m-...

[Shachar_Tal]

Unfurtunately it did not work... As described in the other thread it lead to an error

[Jakinta]

Help us help you.

Upload some sample data in tabular format and desired result as well....

[Shachar_Tal]

Thanks a lot, I believe this will work...