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

Ashish_Mathur's avatar
Ashish_Mathur
Super 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.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    Share the link from where i can download your Excel file.

    • asif082's avatar
      asif082
      Frequent Visitor
      7 years ago

      Hi Ashish,

       

      I can't share a link as the data is connected to login based so you won't see thing any other suggestion?

       

      But data is coming from 3 tables and the relationship diagram I have shared. And in engaments Substantive and acting details come.

       

      Position Title and Postion type comes from position List

      Position ID and Acting date comes from Engagements List

      Grades from grades List

      Substantive Full Name and Acting Full name comes from Employee List.

       

       

       

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

         

        Type the 16 rows of data which i see in your post into an Excel file and then share the link from where i can download your Excel file.