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
Icon for Super User rankSuper 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.