Forum Discussion

Asma's avatar
Asma
Frequent Visitor
9 years ago
Solved

NOW() function

Hi, I want to add a column that indicate if the year is the current year, a previous year or next year , I have already a calender Table called Dates, so I tried this Dax function but it didn't work ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago
    YearSlice = IF('Dates'[Year]=YEAR(NOW()),"Current Year",IF('Dates'[Year] = YEAR(NOW())-1,"Previous Year",IF('Dates'[Year] = YEAR(NOW())+1,"Next Year","Other Year")))
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago
YearSlice = IF('Dates'[Year]=YEAR(NOW()),"Current Year",IF('Dates'[Year] = YEAR(NOW())-1,"Previous Year",IF('Dates'[Year] = YEAR(NOW())+1,"Next Year","Other Year")))
  • Asma's avatar
    Asma
    Frequent Visitor
    9 years ago

    Thank you  Greg_Deckler  for your help