Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Summaries Table using data from two tables

Hi Experts   I have two tables A and B, i want to take from Table A the Customer_ID and from Tables B the Month_Start_Date, Roll_Period and the. there is not Customer_ID in table B the two tables a...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    7 years ago

    Hi Anonymous ,

     

    If there is an actual date key column link the Table A and B, you can use the NaturalInnerJoin or NaturarLeftOuterJoin to combine two tables such as following DAX.

     

    Table =

    NATURALINNERJOIN ( ALLEXCEPT ( A, A[Datekey] ), ALLEXCEPT ( B, B[Datekey] ) )

     

     

    If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

     

    BTW, pbix as attached.

     

    Community Support Team _ DongLi
    If this post helps, then please consider Accept it as the solution to help the other members find it more 

v-lid-msft's avatar
v-lid-msft
Community Support
7 years ago

Hi Anonymous ,

 

If there is an actual date key column link the Table A and B, you can use the NaturalInnerJoin or NaturarLeftOuterJoin to combine two tables such as following DAX.

 

Table =

NATURALINNERJOIN ( ALLEXCEPT ( A, A[Datekey] ), ALLEXCEPT ( B, B[Datekey] ) )

 

 

If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

BTW, pbix as attached.

 

Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Team _ DongLi, many thanks execellent feedback as always.