powerbidaxreportbuilderdaxstudio

How to join three tables with relationship using DAX only


I need a help here. I have 3 datasets in power BI having relationships. Now, I have to use these power BI datasets in Power BI Report Builder. I need to join these three tables using DAX only in Power BI Report Builder. I am trying the below code but the code only works with two tables. How to join the 3rd table?

DAX query that does not work -

EVALUATE NATURALLEFTOUTERJOIN(
 'PortalUser_SiteInformation',
 'OverviewTrainingCompleted',
 'CourseDetails'
 )

The above code works if I remove 1 table from the above query.

Below is the screenshot of relationship between these tables:-

All 3 tables have relationship with column User_id. Below is the screenshot of Power BI Report Builder

I Know how to join tables in PowerQuery but I have only option to join in Power BI Report Builder. Please help me to join these three tables in DAX.

Thanks in Advance..


Solution

  • You need to check the requirements for the join conditions in DAX for NATURALLEFTOUTERJOIN():

    FullJoinConditions

    It seems that Your Middle Table(PortalUser_Siteinformation) has a different column name than the other 2.

    I recommend you to check full requirements(column names, data types, lineage etc.. ) of your tables involved.

    And after fixing that, You can try this DAX Code:

    EVALUATE
    NATURALLEFTOUTERJOIN (
        NATURALLEFTOUTERJOIN (
            'PortalUser_SiteInformation',
            'OverviewTrainingCompleted'
        ),
        'CourseDetails'
    )