Show records from 2 diferent tables in 1 table

[lean2050]

Hi everybody,

This is my data model:

I've created 2 tables. One has users that have worked on an incident (PMO-2737), and the other one has users that have worked on subtasks of the same incident (PMO-2737)

What I would like to generate is a table that has all that information together. I mean, incident, author and timeworked:

With this link you can download the DataSet and tables created on PBI:

https://drive.google.com/file/d/1j37TbRTXFTW_6-UZl2oG6psSt3sRO8To/view

Thank you all!

Regards

[DOLEARY85]

Hi,

you could either union the tables together in a calculated table:

or

append them together in power query, which would be the best for perfomance:

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[lean2050]

Thanks DOLEARY85 for your quick reply!

I've tried that approach, but it doesn't help me, because I need the incident field. 

How do I know that last records are from PMO-2737 or from anotherone?

Thanks

[DOLEARY85]

Which approach did you try the append or union?

[lean2050]

The append.

[DOLEARY85 · Accepted solution]

Ah okay, 

I can see the issue you'll need to merge the sub task table into the bitacora subtask to get the parent id first - rename the columns then append.

I've updated the file for you to take a look at:

https://drive.google.com/file/d/1-YAMIgt8UO1LCo1ErFV5M8hu3KwFMiEV/view?usp=share_link

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[lean2050]

That worked perfectly! Thank you very much!

Regards,

Lean

[DOLEARY85]

No problem, happy to help 🙂

[lean2050]

I also tried with the Union approach, and obtain the same result: