Text and Integer date comparison for current month

[zraopingm]

Hello,  trying to get current month sum:

I tried to change month to date type, it does not allow me. 

I also tried to change year data type as text, same as month, it does not work either. 

Image 2 works, but then I will have to change the month NO for every month. 

thank you Zoey

Image 1:

image 2:

[jgeddes · Accepted solution]

MONTH() returns a number. 
If your Date[Month] column is the column name then that is the source of the error. 
If you have a Date[Month No] column that returns a number then

Calculate('TASK MEASURE'[TASKS_APPROVED], 'Date'[Year] = YEAR(TODAY()), 'Date'[Month No] = MONTH(TODAY()))

should work.

[zraopingm]

Yes!! thank you 

Zoey