Forum Discussion
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 are join via a date column (not Month_Start_Date) another date field.
How could i summarise the two tables into one new table.
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
3 Replies
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
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
