Forum Discussion

asif082's avatar
asif082
Frequent Visitor
7 years ago

Merge Rows with data from three Table Urgent help please!

Hi Everyone,   I have 3 tables which producing below result.    Current Outcome                                   Desire Result   what I need is I want to merge duplicat...
Need Help
MFelix's avatar
MFelix
Super User
7 years ago

Hi asif082,

 

On your Current Outcome do a grouping by then add all your columns to the Goup by option and on the Part Time select the option MAX.

 

This should give expected result.

 

Regards,

MFelix

  • asif082's avatar
    asif082
    Frequent Visitor
    7 years ago

    Hi,

    Thanks for the reply, but the problem is all the names come from Employee Table.

     

    so I have these 4 tables, Position, engagement, Grades and Employee

     

    Enagement is where all the data is link via ID's from those three table. 

     

    so the screen shot I have sent earlier is actually a Table visualization in power BI  and when I go in edit quries mode how I group by from different tables?

     

    Thanks

     

    • v-danhe-msft's avatar
      v-danhe-msft
      Microsoft Employee
      7 years ago

      Hi asif082,

      From your description, you could also follow the MFelix 's function to group your data by [ID] due to your row data table have no [Name] column, if it still could not solve your problem, could you please offer some sample data to have a test?

       

      Regards,

      Daniel He