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 

 

 

 

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
7 years ago

asif082

 

Did you tried the Groupby function with ProdID.

 

 

Can you please share some sample table here. 

 

 

    • Baskar's avatar
      Baskar
      Icon for Resident Rockstar rankResident Rockstar
      7 years ago

      asif082 Try this 

    • Baskar's avatar
      Baskar
      Icon for Resident Rockstar rankResident Rockstar
      7 years ago

      • asif082's avatar
        asif082
        Frequent Visitor
        7 years ago

        okay yeah this worked thanks alot. The real data is coming from big table so I belive all I need is to use related or some dax function to extract data from master table and use group by on this new table right?