Forum Discussion
basic question regarding Power BI Relationship (compared to join in SQL)
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:
Thank you, but is there a way to create the different types of join in the model view and not on DAX?
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.