Forum Discussion
Creating a new table for each unique value in a column
I have a source spreadsheet with three columns.
Column A contains a list of table names, Column B and C are mapping/conversion fields for those tables.
Example snipett:
e.g. Dimension table contains DimensionTitle field which is named "Title" on the system
My task is to create a conversion table to automatically rename those columns, however rather than do this manually for each table, I wondered if there's a way to use the values in Column A to automatically convert the spreadsheet into as many tables as there are unique values?
You cannot dynamically add queries in Power Query.
6 Replies
You cannot dynamically add queries in Power Query.
"You can't dynamically ... in Power BI/Query"I'm coming from Qlikview/Sense universe and finding many answers like that...
So I'm thinking that Qlik isn't too bad as I used to say
Wait until you try to create dynamic buckets 🙂
Hi, Anonymous ;
Try to create a new table by dax.
new = VALUES ( 'table'[column] )Or
new = SUMMARIZE ( 'table', [column1], [column2] )
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
