Forum Discussion

AI14's avatar
AI14
Helper III
3 years ago
Solved

if statement time

Hi   my measure doesnt seem to work. i want to show a 1 if the task duration is less than the clean sla.     Task duarion is a measure that does outbound_st - sta & Clean SLA is a column i manua...
  • tamerj1's avatar
    3 years ago

    Hi AI14 

    try

    test01 =
    IF( TIMEVALUE ( [TaskDuration] ) < SUMX(clean,clean[Clean SLA]),1)