topic Re: Create a column in table A that calculates values from Table B using date filter in DAX Commands and Tips

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

ozturkk — Wed, 06 Dec 2023 07:23:43 GMT

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()

)

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

ozturkk — Wed, 06 Dec 2023 07:25:35 GMT

l have also tried this to no avail:

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

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

Fowmy — Wed, 06 Dec 2023 07:44:09 GMT

ozturkk

Please try this:

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

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

ozturkk — Wed, 06 Dec 2023 07:54:20 GMT

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