Current Year for filter

[TomBond77]

Hi experts

What's wrong with this expression?

={$<Year={$(=<Calendar.Year(Today())}>}

The formula syntax check says "OK", but the dimension shows "invalid dimension".

Thanks for your help.

Kind Regards

Tom

[TomBond77]

I also tried this version, but not working too.

={<Calendar.Year={$(=<Calendar.Year(Today())}>}

[agigliotti · Accepted solution]

Hi @TomBond77 ,

maybe this:

=Aggr( only( {< Calendar.Year = {"$(=Year(Today()))"} >} Year ), Year )

I hope it can help.
Best Regards

[TomBond77]

wonderful