Join between tables

abenlazreg

New Member
Joined
Jun 6, 2019
Messages
1
Hello,
Regarding the binding of tables in Power BI, I would like to know how to make this connection, in the habitiude in SQL, we do the join or the connection between the tables with a primary key, but in Power BI I noted that There are linked tables with other fields.
For example in this screenshot, I would like to join these two tables Stock and orders, Can we join them with the fields date or Year, or month or company since they exist in the two tables? And what is the difference between joining with a primary key and joining with a normal field?
Join between tables
I thank you in advance.
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Forum statistics

Threads
1,089,240
Messages
5,407,088
Members
403,125
Latest member
vbambre

This Week's Hot Topics

Top