Forum Discussion
Solved
basic question regarding Power BI Relationship (compared to join in SQL)
HI, Coming from the SQL world, I have a question regarding "relationship", is it like "join" in SQL? If it is, what would be the equivalent in "relationship" to inner join/ outer join? Thanks...
No, in the model view on the basic left outer is a possibility.
The best way to join tables is always by leveraging physical relationships in the data model, because it results in simpler and faster DAX code. While there are other techniques using DAX, these techniques are more expensive from a performance point of view and also result in a more complex DAX code.
They are like left outer joins by default. When writing a SQL query you have to define joins, in DAX the joins are implicit
Thanks, can you please let me know what would be the cardinality and cross filter direction to create the following:
1. Inner join
2. Left join
3. Right join
4. Full outer join
For example I have the following case:
