DAX - Join two tables on multiple columns with live connection

[Anonymous]

Hi Community,

Does any know the DAX expression to use when I need to join 2 tables on 5 columns.  Note, I am using a live connection to SSAS.  On a super tight deadline. Please and Thank you to anyone that can help!!  😁

Michelle

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

In DAX language, we use NATURALLEFTOUTERJOIN() and NATURALINNERJOIN() to join tables, but you can’t set the join columns for the two tables. The join condition is based on columns having the same name in the tables involved.

In my opinion, I prefer to do the data modeling operations in the SSAS database, because when we use a live connection to connect to SSAS in Power BI. The data model is created and stored in the data source instead of Power BI. Power BI can only connect to it and query the data in real-time.

What’s more, the amount of data in SSAS is particularly large. Using DAX to re-associate tables in power bi will have a great impact on the efficiency of reports and data, so I don't recommend you to do so.

Joining tables using DAX

Data modeling in SSAS Tabular model

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks Robert, that is what I'm gathering here with all my research.  Appreciate the response.

Michelle 😁

[Anonymous]

@marcorusso