Using join functions in DAX

[@thosethere]

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

[@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!

[@masoudpesaran9721]

Gr8 presentation, very informative. Thank you.

[@teigenxayden]

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

[@gvitullib]

Thanks Marco!

[@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

[@ПавелЛинев-ч7м]

bellissimo!