Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

  • 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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you very much. It works!

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity 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

  • Anonymous's avatar
    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?