title: DAX formula for Time
body: <p><strong>Time formula in Power BI</strong></p>
  
  <p>What I am trying to do:
  If any train departed <code>&gt;= 59 sec</code>, then <code>"1"</code>, or else <code>"0"</code>.</p>
  
  <p>The formula I am using:</p>
  
  <pre><code>=if([Actual-Planned]&gt;=time(00,00,59),"0","1")
  </code></pre>
  
  <p>This is partially working. It does give me <code>"0"</code> in the case where <code>actual-planned</code> time is <code>59</code> seconds, whereas per formula it should give me <code>"1"</code>.</p>
  
  <p>It works when I put it as <code>(00,04,59)</code> but does not work for seconds.</p>
  
  <p>Has anyone come across this issue before?</p>