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