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:
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(…)
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?