Duplicating a New Column in Power Query

Hi Anonymous ,

According to your description, here's my solution. My sample data is as below.

Table :

User table:

Solution1:

Select the User column in User table, then click "Merge Queries"

Select User column in another table.

In the result column, expand Department column.

Solution2:

Add a custom column:

Table.SelectRows(#"Table", (x)=> x[User]=[User])[Department]{0}

Both get correct result:

I attach my sample below for your reference.

Best regards,

Community Support Team_yanjiang

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