Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ale_g
Frequent Visitor

How to join two tables

Hi, everybody!
i'm new usign power bi and need some help with a issue i can't solve.
I have two tables that I need to join
table A

Ale_g_0-1664399331723.png

table B

Ale_g_1-1664399381708.png

i need that the resulting table looks like these:

Ale_g_2-1664399673984.png

I trully appreciate any help, thanks!

 



2 REPLIES 2
Alta88
Helper IV
Helper IV

Hey there! So you'll need to create relationship between the two tables so that your final table visual will display the information from both tables. 

 

First import your tables directly into Power BI.

 

Then, go to the following icon:

 

Alta88_0-1664400140897.png

 

 

From there, click on "Manage Relationships" in the top menu:

 

Alta88_1-1664400188365.png

From there, you'll select Table A in the first drop-down field and Table B in the second drop-down. 

Alta88_2-1664400753411.png

 

The tables will appear and you'll need to select which columns you want to link (they will be shaded in gray). In your case I believe it will be "Periodo".

 

Once both are selected, in the Cardinality field below, click on "Many-to-One" and check the "Make this relationship active" checkbox. 

 

This is because you have several types of "Horas" per one "Periodo" type. 

 

Once you've selected the options, click "OK" and "Close" and it will load the connections between the tables. 

 

From there, you'll go to the Report view: 

 

Alta88_3-1664400812889.png

 

Then, in the Visualizations pane, select the following: 

Alta88_4-1664400859693.png

 

A blank table will appear and you can drag in the fields from your imported tables in the Fields pane.

 

Alta88_5-1664401061054.png

 

For example: this chart now has data in it and the fields are under the "Visualizations" pane, where you can edit them under the using the top highlighted icons. 

 

Alta88_6-1664401226532.png

 

Ale_g
Frequent Visitor

thanks for the reply, i appreciate it.
but, in these, case what i need as result is a calculate table to work with it later.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.