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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to create a table with two new columns based on the two tables of values in Power Query

I have one table with one column called stores:

 

Stores

A

B

C

 

 

And I have another table called channels:

 

Channels

1

2

3

 

 

I need to create a new table with two columns "Stores" and "Channels" like this in Power Query

 

Stores      Channels

A              1

A              2

A              3

B              1

B              2

B              3

C              1

C              2

C              3

 

For each store, there will be 3 channels. 

 

Is there any way to achieve this in Power Query? Thank you!

1 ACCEPTED SOLUTION
NishPatel
Resolver II
Resolver II

Import both tables into the Power Query. Select Stores table and add Custom Column Channels and Enter formula = #"Channels"[Channels]. Expand the Channels column by selecting Expand to New Rows. And you will achive what you need as below.

NishPatel_0-1664971028524.png

 

View solution in original post

5 REPLIES 5
NishPatel
Resolver II
Resolver II

Import both tables into the Power Query. Select Stores table and add Custom Column Channels and Enter formula = #"Channels"[Channels]. Expand the Channels column by selecting Expand to New Rows. And you will achive what you need as below.

NishPatel_0-1664971028524.png

 

Anonymous
Not applicable

Thank you very much. It works!

HotChilli
Super User
Super User

https://learn.microsoft.com/en-us/power-query/add-custom-column 

Have a read of this then try my suggestion.

Work your way through it and I will help if you have specific problems

Anonymous
Not applicable

Thank you! I don't quite get what you meant. Would it be possible to add a few more detailed steps like screenshots etc? 

HotChilli
Super User
Super User

Add a custom column to table1 with the name of the other table and column , for example, 

Table2[theColumn]

then expand to new rows

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors