Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

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

hasrya_0-1669738620381.png

 

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?

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

You cannot dynamically add queries in Power Query.

View solution in original post

6 REPLIES 6
lbendlin
Super User
Super User

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 🙂

Anonymous
Not applicable

I suspected so but thanks for confirming!  

v-yalanwu-msft
Community Support
Community Support

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
Not applicable

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.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors