Newly added column does not show up when trying to expand column

[Anonymous]

Hi all,

So I have a table called "Table1" i Power Query, where I newly added a new column called "Col1". 

Table1 is merged with Table2, so that it is possible to expand Table1 in Table2.

However, when trying to expand Table1 in Table2, the newly added column Col1 does not show up. Only the first already set columns shows up. 

I want to expand Table1 to show Col1 in Table 2.

Have anyone encountered this problem before?

I appreciate all responses and suggestions.

Thank you,

Frode

[Anonymous]

Hi @Anonymous ,

Please check your join kind whether the kind applies to you.

Then check whether your matching columns can be matched correctly with the column in table 2.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HotChilli]

Link your pbix and i'll have a look at it

[Anonymous]

Hi @HotChilli ,

I cant link my pbix, as there are company confidential info on it.