How to use the logical operator "Between" in two times (hours)

[Ivanfa23]

Hi community,

I have one culumn with format time (ej. 20:00:05, 05:52:00, etc.),

I want to use the IF formula for search for all records that are between 23:00 and 05:00. I try with the next formula:

Cruce = IF(Iave[Hora de Cruce ]>TIMEVALUE("23:00:00") && Iave[Hora de Cruce ]<TIMEVALUE("05:00:00"),1,0)

but doesn´t work. Any suggestion for resolve this?

Regards.

[v-yuezhe-msft]

@Ivanfa23,

The formula MarcelBeug provides also works well in my environment. What version of Power BI Desktop do you use? Would you mind sharing me your PBIX file?

Regards,

[MarcelBeug]

It should be OR (||), not AND (&&).

[Ivanfa23]

Hi, I already tried with AND (&&) and OR (||), but doesn´t work, when I do with AND (&&) all records are 0, when ! do with OR (||) all records are 1. Any other idea? Regards.

[MarcelBeug]

It works fine with me, but notice the trailing space in column name "Hora de Cruce ".

[Ivanfa23]

I tried it again but it doesn´t work

I have Power BI Desktop Free, do you think that's the problem?

P.D. I remove the blank of "Hora de Cruce".

Regards.

[MarcelBeug · Accepted solution]

I have the free version as well.

My suspicion is something wrong with your time values, maybe those are regarded as minutes, seconds, fractions or something.

If you try and shift your TIMEVALUE("05:00:00") to TIMEVALUE("00:15:00"), what happens?

Just a wild shot, actually I don't understand either why it isn't woking for you.