cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gofgabriel Frequent Visitor
Frequent Visitor

join tables with common columns

Hello,

I'm having difficulty to building a join/union of three tables that have similar columns, but with different i number of colum and alias on it. In my case I just wanna use the id_number, user, and description and put it in a block of table.

Any idea what I'm doing wrong or how I can get a solution?


I tried DAX using UNION + SUMMARIZECOLUMNS or UNION + SUMMARIZE but didnt work out

 

For example, this is one of the tables I need to join with three fields in common.

Capturar2.PNG

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: join tables with common columns

Hi @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] )
)

3.PNG

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

gofgabriel Frequent Visitor
Frequent Visitor

Re: join tables with common columns

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:

Capturar2.PNG

In the end all those information will be put in a table block to be show together and also able to filtered.

Sem título.png

gofgabriel Frequent Visitor
Frequent Visitor

Re: join tables with common columns

No tips for this problem guys? 😞

mussaenda Senior Member
Senior Member

Re: join tables with common columns

You can append these tables in power query. Just make sure the column names of the different tables are the same.

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 143 members 1,616 guests
Please welcome our newest community members: