I have a table holding only dimensions, no measures. I wish to filter the table via a date field so only 2021 will show up using aggr & only (since I cant use set analysis). The date field looks like this: dd/mm/yyyy I've tried using =aggr(only({<num(year(Date))={num(year(today()))}>}Date), Date) to extract the year but all I get is nulls.
That's what I've been asked. The table should show only certain year. Basically I've succeeded in doing this using "if" but I wish to see if there is another option.
