Cant seem to figure out why this expression doesn't give me the sum of the revenue - per that branch

[Tiger1]

I wrote an expression to give me the revenue of a certain branch (based on _THISROW) and the it is the current month.
I have data in the table and it keeps giving me $0 as the value.

My expression:
SUM(SELECT(Revenue Table[Revenue], AND(
Month([date]) = [Month],
[branch] = [_THISROW].[branch])
)
)

[hru]

Tiger:

Month([date]) = [Month],

Is [Month] a number type column?

Maybe also check using EOMONTH to get the current month, such as:

SUM(
	SELECT(Revenue Table[Revenue],
		AND(
			EOMONTH([date],0) = EOMONTH(TODAY(),0),
			[branch] = [_THISROW].[branch])
		)
	)

[anonymous]

@Tiger can you share a screenshot of your table?

[Tiger1]

Yes - [Month] is a number.

[Tiger1]

[Tiger1]

That worked. Thanks