Lookup value based on multiple criteria from another table

Hi Anonymous 

Add one column as a Date-Name to both the First and the Second Table with this code:

Date-Name = 'Second Table'[Date]&"-"&'Second Table'[Name]

Then try this code to add a new table:

Table =
ADDCOLUMNS (
    SUMMARIZE (
        'First Table',
        'First Table'[Date],
        'First Table'[Name],
        "Total", SUM ( 'First Table'[Total] )
    ),
    "Amount",
        CALCULATE (
            SUM ( 'Second Table'[Amount] ),
            ALLEXCEPT ( 'Second Table', 'Second Table'[Date-Name] )
        )
)

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos✌️!!