Creating a new table for each unique value in a column

[Anonymous]

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?

[lbendlin · Accepted solution]

You cannot dynamically add queries in Power Query.

[renatogbarroso]

"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

[lbendlin]

Wait until you try to create dynamic buckets 🙂

[Anonymous]

I suspected so but thanks for confirming!  

[v-yalanwu-msft]

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.

[Anonymous]

Hi there thanks for your reply.  Unfortunately I need to do this in power query not in the data model.  I will resort to some VBA to split out the excel table into multiple tabs instead.