Set expression to get current month values

[ajmalh]

Hi All,

I'm getting zero value while using the below set expression. I'm trying to show the current month values in the expression.

Kindly help.

=count({<canonical_date ={"$(=monthname(today()))"}>} If(WildMatch(platform_name_a, '*ABC*'),pfas_id))

Also, I have attached the table snap.

[BrunPierre · Accepted solution]

Try below.

Count({$<canonical_date={"$(='>='& Date(MonthStart(Max(canonical_date)))&'<='&Date(Max(canonical_date)))"},platform_name_a={"*ABC*"}>}pfas_id)