Forum Discussion

asif082's avatar
asif082
Frequent Visitor
7 years ago
Solved

very urgent help needed

I needed some help with Power BI I need to merge or group by Position ID. Please see below image.

 

Please help with this, thanks alot....

 

Need Help

18 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

     

    In the Query Editor, click on the 5th column and go to Transform > Fill > Down.  Now select the first 4 columns, right click > Remove Duplicates.

     

    Hope this helps.

    • asif082's avatar
      asif082
      Frequent Visitor
      7 years ago

      Thanks Ashih for the reply but the solution you proposed is not working, removing duplicates removed the correct row too.  see below 

       

       

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        7 years ago

        Hi,

         

        You have to select the first 4 columns and then right click > Remove Duplicates.  If it still does not help, then share the link from where i can download your PBI file.