Forum Discussion

SK2's avatar
SK2
New Member
2 years ago

Remove Duplicate rows by getting value in separate columns

Hi , I am new to Power BI and trying to remove duplicates. Can anyone please help me with this?   This is what i have  And trying to get it like below. Thanks for your time
Need Help
Erokor's avatar
Erokor
Icon for Resolver II rankResolver II
2 years ago

In Power Query, you can use the "Transpose" feature. Which should get you what youa re looking for. However, you'll need to re-title your column headers.

 

Alternatively in a "Matrix" visual. You can put the "SH" in the "Rows" portion, and the "Status" in the "Column" and "Values" portion of the visual. You'll also want to set your Aggrigation's appropriately for the "Values" so that it does not sum/count etc.

  • SK2's avatar
    SK2
    New Member
    2 years ago

    I tried the matrix visual , and it shows me this 

    I added "status" in values portion of visuals - but it changes to count of status .And shows like 

     

    • Erokor's avatar
      Erokor
      Icon for Resolver II rankResolver II
      2 years ago

      If you select the little carrot to the right of the "Count of Status" you can then adjust that to "First" or last. Since you only have the value once for each number in the header it would show 1 for 1.

       

      This is really a hacky way to do it. The better way would be to model your data properly up front (using Transpose as I mentioned before).

      • SK2's avatar
        SK2
        New Member
        2 years ago

        Got it . i tried the other way also