IF function with time column

[KGBOR]

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 is over 00:00:45 and a 0 if it's equal or below that. I did use this function before however I never got a syntax error for that. Any suggestions? Thank you!

[ryan_mayu · Accepted solution]

@KGBOR 

is this what you want?

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

[Anonymous · Accepted solution]

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

I hope that helps 

[KGBOR]

Indeed it did! Thank you! Is there any specific reason why it only works with the TIME function? I've used it with other time formatted columns (e.g. for deductions) and I did not have to use this additional function. Thanks again!

[ryan_mayu · Accepted solution]

@KGBOR 

is this what you want?

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