Using join functions in DAX

NATURALLEFTOUTERJOIN and NATURALINNERJOIN are not commonly used in DAX because they do not have the same flexibility as the corresponding concepts in SQL.
Article and download: sql.bi/823482?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...

[@Milhouse77BS]

On vacation, so I have time to listen to a sqlBI video! Thanks!

[@RobertoStaltari]

Same here. Time off is the only opportunity I have to really delve into these. Bravo!

[@thosethere]

Thank you, for someone who comes from TSQL this is very informative.

[@masoudpesaran9721]

Gr8 presentation, very informative. Thank you.

[@teigenxayden]

THX FOR YOUR SHARE AND THE VIDEO IS SO LONG AND SO GREAT!

[@gvitullib]

Thanks Marco!

[@user-yo2nb4ry7i]

bellissimo!

[@teigenxayden]

I want to know NATURALLEFTOUTERJOIN and NATURALINNERJOIN fuction have the same effect with the fuction TREATAS when no relationship between tables.

[@SQLBI]

Not from a performance perspective, because TREATAS can be pushed to the storage engine whereas the join functions are always executed by the formula engine.

[@teigenxayden]

@@SQLBI Oh,I SEE, THX VERY MUCH!

[@nishantkumar9570]

Is there any way we can establish and use relationship between two tables based more than one columns without creating third concatenate columns in both the tables

[@nishantkumar9570]

Thanks so much, my query is answered.
So, if we have same columns names, we don't need relationship at all?

[@SQLBI]

It depends on which table, a table in the model has a data lineage so the column names are different, it's table[column] and not just [column].
We'll publish another article in a few weeks with more examples about that.

[@tibobago]

😅​@@SQLBI