https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables
The SQL language offers the following types of JOIN:

INNER JOIN
OUTER JOIN
CROSS JOIN

The result of a JOIN does not depends on the presence of a relationship in the data model. You can use any column of a table in a JOIN condition.
In DAX there are two ways you can obtain a JOIN behavior. First, you can Read More →