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

8 Replies

  • Erokor's avatar
    Erokor
    Resolver 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
        Resolver 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).