Forum Discussion

asif082's avatar
asif082
Frequent Visitor
8 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
  • Anonymous's avatar
    Anonymous
    8 years ago

    asif082

    Groupby is the solution in Power Query

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 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
8 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
    8 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    asif082

     

    Did you tried the Groupby function with ProdID.

     

     

    Can you please share some sample table here.