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
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