Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    You cannot dynamically add queries in Power Query.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

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.