current year / current month

[Tommmy]

Hi experts

The following code works fine:

if([Product]<>'', Sum({<Month={'Aug'},Year={'2022'}>} [Quantity]), 0)

This formula doesn't work, any ideas?

if([Product]<>'', Sum({$<Month={"$(={month(today()))"},Year={"$(={year(today()))"}>} [Quantity]), 0)

Thank you, Tom

[Or · Accepted solution]

{$<Month={"$(=month(today()))"},Year={"$(=year(today()))"}>}

There's excess '{' in each of your formulas for month and year.