Forum Discussion

jenani_user's avatar
jenani_user
Frequent Visitor
2 years ago
Solved

Matching alternate columns in powerbi

Hi Team, As shown I have table with more than 60 columns which contains two sets of data in alternate columns, I need to find the unmatched values in the columns and get output as shown Outpu...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  jenani_user ,

     

    Here are the steps you can follow：

    1. In power query – select [A.acc], [B.acc], [A.text], [A.text].

    2. Select [Value] – Group By.

    3. Select [ALL] – Select the columns you want.

    4. Select [Count] -- 1.

    5. Select [Count] and [ALL.A.id] – Remove Columns.

    6. Select [ALL.Attribute] – Pivor Column.

    7. Result:

     

    Best Regards,

    Liu Yang

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  jenani_user ,

 

Here are the steps you can follow：

1. In power query – select [A.acc], [B.acc], [A.text], [A.text].

2. Select [Value] – Group By.

3. Select [ALL] – Select the columns you want.

4. Select [Count] -- 1.

5. Select [Count] and [ALL.A.id] – Remove Columns.

6. Select [ALL.Attribute] – Pivor Column.

7. Result:

 

Best Regards,

Liu Yang

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