Forum Discussion

effertz12's avatar
effertz12
Icon for Helper II rankHelper II
5 years ago
Solved

Will Calculated Column based on date change when month changes automatically

I am currently using this formula to add a calculated column to my data  CurrentMo = IF(STEPCHART5[Month].[MonthNo]>=MONTH(TODAY()),"yes","no"). I am using this to filter out future months on cert...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    effertz12 , yes, as this based on today this should change

    if month is a date then prefer

    CurrentMo = IF(month(STEPCHART5[Month]) >=MONTH(TODAY()),"yes","no").

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

effertz12 , yes, as this based on today this should change

if month is a date then prefer

CurrentMo = IF(month(STEPCHART5[Month]) >=MONTH(TODAY()),"yes","no").