Forum Discussion

Satish_Kumar's avatar
Satish_Kumar
Icon for Helper V rankHelper V
9 years ago

how to join two tables.

Hi All, i want to know how can i join two tables with a common feild to make a resultant table.
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Satish_Kumar,

Actually i have created realtionship between the  tables but i have to summerize the amount feild based on id which is in different table that why i need a join to create a new resultant table.

As you have created a relationship between the two tables, you don't need a join to create a new resultant table to summarize the amount field based on id which is in different table. You can just use the formula below to create a calculate column in the second table to summarize the amount field in first table.

Amount = CALCULATE ( SUM ( Table1[Amount Including Tax] ) )

 

Regards

Satish_Kumar's avatar
Satish_Kumar
Icon for Helper V rankHelper V
9 years ago

hi v-ljerr-msft 

yes i have done that too. but will you please send me a syntax of joining two table in DAX to make resultant table.

beside of this exaple.

And Lastly thanks for help.

 

Reagrds,

Satish Kumar

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Satish_Kumar,

     

    Have you tried to make the resultant table in Query Editor as BhaveshPatel mentioned above? It should work.:smileyhappy:

     

    Regards