transfrom data

[Mohitk]

i have a 2 table and it has no source but i want to join the 2 table and i want to join the 2 table and i want to append in it how can do ,and also want to transfrom data in them  @Ahmedx 

[Ahmedx]

I don’t understand, can you show an example of what you want?

[Mohitk]

Sure, 

"I already have a Power BI file without any source; it contains two tables. I need to append or join this data because when I use any visual, only values from one table are displayed. I want both tables' values to appear in a single visual. How can I achieve this?"

[Ahmedx · Accepted solution]

Refer to this solution

power query merge tables

https://www.youtube.com/watch?v=MQlMtXvjBBo&ab_channel=dr_transforma%C3%A7%C3%A3odigital