Create a column in table A that calculates values from Table B using date filter

[ozturkk]

I'm a new user, so bear with me:

I have a pretty simple data set in Table B that has data for when each ID is expected to receive revenue.  It looks like this:

So there can be multiple rows for each ID.  I want to create a new column in Table A (which has only one row for each ID) that brings the total income for each project when the date is today or earlier.  

I tried this, but it is bringing me the same value for all IDs:

Bugüne Tahmini Gelir =

 CALCULATE(

    SUM(TableB[INCOME]),

    CALCULATETABLE(

        VALUES(TableB[ID]),

        TableB[Date] <= TODAY()

    )

)

[Fowmy]

@ozturkk 

Please try this: 

Bugüne Tahmini Gelir =
VAR __Date = TODAY()
RETURN
 CALCULATE(
    SUM(TableB[INCOME]),
        TableB[Date] <= __Date
    )

[ozturkk]

Thank you for your reply. Sadly, I am still getting the same value for all IDs

[ozturkk]

l have also tried this to no avail:

SUMX( VALUES('TableB'[ID]), CALCULATE( SUM('TableB'[INCOME]), 'TableB'[DATE] <= TODAY(), 'TableB'[ID] = EARLIER('TableB'[ID]) ) )