Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

IF Statment using DateDimension Table

I would like to make an IF statement based on the date in my DateDimension Table. Date is calculated as: DateDimension = Calendar(Date(2018,12,23),Date(2019,12,31))   I would like to write an If ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Try:

     

     

    Category = IF(DateDimension[Date]=DATE(2019/1/1),"Holiday","NA")

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Try:

 

 

Category = IF(DateDimension[Date]=DATE(2019/1/1),"Holiday","NA")