Get the total sum of monthly income from my budgeting app

[Whismark]

Hi,

I have a budgeting app. I record the daily net income, but i want to get the monthly net income. what is the formula for this?

[lynchk21]

Try something like:

SUM(
SELECT(
table_name[daily net income],
AND(
MONTH([date column]) = MONTH([_thisRow].[Date Column]),
YEAR([date column]) = YEAR([_thisRow].[Date Column])
)
)
)