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.
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.
Exactly, I would like to use physical relationships in the data model to create the following joins:
create the following:
1. Inner join
2. Left join
3. Right join
4. Full outer join
What do I need to specify under cardinality and cross-filter direction to create each one of the joins above (1-4):