MTD Expression suddenly not working

[#1]

I had this MTD expression working for almost a month and suddenly something went wrong and I am unable to figure it out. May be it is something small that I might be missing here.

This is the expression

Sum({<[Year] = {$(=Year(Today()))},[Month]={$(=Month(Today()))}>}Sales)

It Calculates MTD sales

Any suggestion will be helpful. Thanks

[SunilChauhan]

use below code hope this helps

Sum({<[Year] = {$(=Year(Today()))},[Month]={"<=$(=Month(Today()))"}>}Sales)

[#3]

Sunil This is not working..

[Anonymous · Accepted solution]

Logic looks fine.  Check the format of the data, make sure that Month(today()) has the same format as field Month.
Or, maybe there are Sales data yet in the current month?  It just started...

[#5]

Hi Michael... Thanks for pointing it out. You were right. The feed to my application broke and I had no data for the Month of May. I kept on thinking April and testing that data.

Appreciate your help!!