Forum Discussion

KGBOR's avatar
KGBOR
Icon for Helper I rankHelper I
4 years ago
Solved

IF function with time column

Hello, I'm stuck at a probably pretty simple issue with the IF function. I have a column in time format (hh:mm:ss) and what I want to do with it is to create another where I get a 1 whenever the time...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    KGBOR 

    is this what you want?

    Column = if('Table'[Column1]>time(0,0,45),1,0)

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi,
    Have you tried using IF((["Date column"])>TIME(00,00,45),1,0)?


    I hope that helps 

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
4 years ago

KGBOR 

is this what you want?

Column = if('Table'[Column1]>time(0,0,45),1,0)