Forum Discussion
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!
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.
5 Replies
- NishPatel
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.
- AnonymousNot applicable
Thank you very much. It works!
- HotChilli
Community Champion
Add a custom column to table1 with the name of the other table and column , for example,
Table2[theColumn]
then expand to new rows
- AnonymousNot 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
Community Champion
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