Forum Discussion
join tables with common columns
Community SupportHi gofgabriel ,
You could try to use the function of GENERATEALL. The following is my sample you can reference.
Table =
GENERATEALL (
GENERATEALL (
SUMMARIZE ( ProjectTickets1, ProjectTickets1[Ticket] ),
SUMMARIZE ( EmployeeRole2, EmployeeRole2[Employee] )
),
SUMMARIZE ( ProjectHours, ProjectHours[Hours] )
)
Best Regards,
Xue
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-xuding-msft, thanks for your reply!
So, I tried your solution, but it didn't work as expected. It joins the data, but in different columns.What I'm trying to do is to join two tables, as if I'm appending one to each other, but making the same information stay in the same column. Also, the relationship with source tables should be maintained because of the report filters.
It's hard to explain, but it's basically:
- column A containing p.number (Problems table) and it.number (ITS table) data
- column B containing p.short_description (Problems table) and it.short_description (ITS table).Example:
In the end all those information will be put in a table block to be show together and also able to filtered.
No tips for this problem guys? :(
- mussaenda
Community Champion
You can append these tables in power query. Just make sure the column names of the different tables are the same.
