Forum Discussion

siva_powerbi's avatar
siva_powerbi
Helper IV
5 years ago
Solved

Merge table using DAX and Create a calculated table

I have 2 tables, I have merged in Power Query and created a Merged table (Columns from both tables), but I need to do the same using DAX without using power Query.   loaded tables into Power BI and...
Need Help
Show and Tell
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  siva_powerbi ,

     

    The .pbix file you share cant be opened;

    I use your sample data for instance:

    First create a relationship between the 2 tables,

    Then create a new table as below:

    Table = ADDCOLUMNS('Table1',"Test 3",CALCULATE(MAX('Table2'[Test3]),USERELATIONSHIP(Table1[Test2],Table2[Test3])),"Test 4",CALCULATE(MAX('Table2'[Test4]),USERELATIONSHIP(Table1[Test2],Table2[Test3])))

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
siva_powerbi's avatar
siva_powerbi
Helper IV
5 years ago

@amitchandak Thanks for reply.

Attached files and data source file.

In Power Query file I was able to merge and create a calcualted table in DAX

In DAX though I have linked I am unable to get the calculated table with columns from both the tables,

I have added a simple example to sum the columns but y original calculation is more complex and need to merge 2 tables in DAX.

Please access files from below link as unable to add pbix files in forum.

https://www.dropbox.com/s/ukfj20r4ro82fus/Forum.zip?dl=0