How to create a Virtual Column with the sum of values of a Column in another Table?

[cboteros]

Hello everyone,

I hope someone can help me with this.

I have a table “EXPENSES” which have a Column “Date” and another column “Amount”.

I have also another table “PERIOD” which has a column “Month” (which is the 1st day of every month) and I want to create a Virtual Column which will be “Expenses Sum within the Month”.

So, in pseudo code, I want to have:

SUM (
EXPENSE[Amount],
IF (EXPENSE[Date] >= PERIOD[Month] AND EXPENSE[Date] < EOMONTH(PERIOD[Month],1)
)

As I understand, since “SUMIF” doesn’t exist, I need to use SUM(SELECT(…) ), but I’m not able to create such SELECT(…)

I’ve tried:

SELECT(
EXPENSES[Amount],
AND(
EXPENSES[Date] >= PERIOD[Month],
EXPENSES[Date] < EOMONTH(PERIOD[Month],1
)
)

But I don’t seem to succeed… Anyone knows what could I be doing wrong?

Thank you!

Carlos B.