IF Statement - Date

[jerryr125]

Hi - I am creating a column a pivot table visualization for a dimension.

I am using the following expression and the IF statement is not working (always going to FALSE).

=IF([skdate.autoCalendar.Year]=2021,skid,null())

Any thoughts ? Jerry

[edwin · Accepted solution]

you may need to supply sample data.  

however, if what you want is evaluate your table only for year=2021, maybe the condition should be in your expression as set analysis instead of dimension.  and it will be faster