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
  • Baskar's avatar
    Baskar
    7 years ago

    asif082

    Groupby is the solution in Power Query

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.