CODEWITHSUNDEEP
powerbidax
user9750080
user9750080

Reputation: 11

DAX formula for Time

Time formula in Power BI

What I am trying to do: If any train departed >= 59 sec, then "1", or else "0".

The formula I am using:

=if([Actual-Planned]>=time(00,00,59),"0","1")

This is partially working. It does give me "0" in the case where actual-planned time is 59 seconds, whereas per formula it should give me "1".

It works when I put it as (00,04,59) but does not work for seconds.

Has anyone come across this issue before?

Upvotes: 0

Views: 92

Answers (1)

user9750080
user9750080

Reputation: 11

right so this is my formula:
=if([Actual-Planned]<=time(00,00,59),"RTSF","RTSA"), which means if any time a train is less than or equal to 59 seconds it will achived Right time start or else fail, i guess i am getting the output now, as i changed to smaller than or equal to instead of greater. Thanks for your help

Upvotes: 1

Related Questions