You can create relationships in Power BI between tables. Relationships are useful for some functions to work across multiple tables and produce the result. Relationship between tables also makes visualization and report elements more efficient, because the result of selection in one chart can affect another chart from a different table. However, there is a limitation in the Power BI relationship that you can't create a relationship based on more than one column. In other words, if you want to create a relationship (or join two tables) with two or more columns, you cannot! Fortunately, there is a workaround that I'll explain in this video.
Read my blog article about this subject here:
[ Ссылка ]

If you like to learn more about relationships in Power BI, read articles below:
The direction of Relationship:
[ Ссылка ]

Active or Inactive relationships:
[ Ссылка ]

Basics of Power BI relationships:
[ Ссылка ]

свернуть