Duration type and logical comparison to a fixed value.

Question

Plese excuse my newbie question.&nbsp;I am trying to get power query to be able to do an IF&nbsp; THEN ELSE using the comaprison of a duration field to a fixed value - if duration is greater than 6 hours, yes else no.&nbsp; &nbsp;I have tried&nbsp;Add Column -&gt; Custom Column -&gt; If [duration column] &gt; "0.05.00.00" then "yes" else "no"&nbsp; &nbsp;The 0.05:00:00&nbsp; I what I am guessing would be 5 hours&nbsp; for the fixed value. Am I even close?

mahoneypat · Accepted Answer

Assuming your [duration colum] has a duration data type, you need to use this syntax to hard code a duration value
&nbsp;
if [duration column] &gt; #duration(0,5,0,0) then "yes" else "no"
&nbsp;
Pat

Forum Discussion

Related content

Logic problem?

Comparison Chart

Logical comparison between different columns?

BI Tools Comparison

FX Conversion Logic