Connect two table with date and common field

[jenani_user]

Hi Team,

Got an issue while connecting two Tables A and B, the table and outputs are as shown below,

Table A

Table B

Expected Output

 But the output I got while connecting two table is as shown below

Kindly help to resolve the issue

Thanks & Regards,

Jen

[v-yiruan-msft · Accepted solution]

Hi @jenani_user ,

I created a sample pbix file(see the attachment), please find the details in it. 

Table = UNION ( VALUES ( 'A'[NAME] ), VALUES ( 'B'[NAME] ) )

NTarget = 
CALCULATE (
    SUM ( 'A'[TARGET] ),
    FILTER ( 'A', 'A'[NAME] = SELECTEDVALUE ( 'Table'[NAME] ) )
)

NAmount = 
CALCULATE (
    SUM ( 'B'[AMOUNT] ),
    FILTER ( 'B', 'B'[NAME] = SELECTEDVALUE ( 'Table'[NAME] ) )
)

Best Regards