IF Condition

[AllanBerces]

Hi gooday can anyone correct my If condtion. What i need is if the week is already pass it should be equal to 0, so from Week 1 to 11 it should be zero and from Week 12 onward should be equal to my forecasthour

FORECAST = IF('Table'[FORECASTHOURS] >  WEEKNUM(TODAY()), 0, 'Table'[FORECASTHOURS])

Thank you

[rohit1991 · Accepted solution]

Hii @AllanBerces 

Your logic is slightly incorrect. You should compare the week column with the current week (WEEKNUM(TODAY())), not the forecast value.

FORECAST =
IF(
    'Table'[Week] < WEEKNUM(TODAY()),
    0,
    'Table'[FORECASTHOURS]
)

[AllanBerces]

Hi @rohit1991 thnak you very much work as i need