How to merge two columns from different sources to one column in table

[ahubinkooo]

Hi,

do you have any idea how to resolve this?

I have two tables which are different (it is not possible to merge them in Power Query) but both of them has colmun "training name" which I need in my table. But the problem is that if I put "training names" data from both tables data are show as two colmuns I need to have them in one colmun. 

My goal is to make an overview of trainings for all roles in our company. So this is the reason why I need have in one column because in other colmuns wil be duration of training, competent person and other informations.

Thank you for your help.

Anna

[amitchandak]

@ahubinkooo , I think, you should create common training dimensions

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...