Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
There is a similar thread. Maybe it can help.
Table.SelectColumns(table, listofcolumns).
You can get the list of columns by using Table.ColumnNames(table) to avoid misspelling
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?
There is a similar thread. Maybe it can help.
Unfurtunately it did not work... As described in the other thread it lead to an error
Help us help you.
Upload some sample data in tabular format and desired result as well....
Thanks a lot, I believe this will work...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.