Forum Discussion
How to join two tables
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:
From there, click on "Manage Relationships" in the top menu:
From there, you'll select Table A in the first drop-down field and Table B in the second drop-down.
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:
Then, in the Visualizations pane, select the following:
A blank table will appear and you can drag in the fields from your imported tables in the Fields pane.
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.