Summaries Table using data from two tables

[Anonymous]

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 are join via a date column (not Month_Start_Date) another date field. 

How could i summarise the two tables into one new table.

[v-lid-msft · Accepted solution]

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]

Team _ DongLi, many thanks execellent feedback as always.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490