How can I check if an hour-type field is in a time range?

[Y-Hernandez99P]

Good morning, my question is how can I check if the x column is in a time range? for example, from 3pm to 4pm?

Thanks for reading.

Here I show how the data is

[v-kelly-msft · Accepted solution]

Hi @Y-Hernandez99P ,

Create a measure as below:

Measure 2 = 
var a =HOUR(SELECTEDVALUE('Table (2)'[Time]))
Return
IF(a>=15&&a<=16,1,0)

And you will see：

The rows which return 1 are in the time period from 3pm to 4pm.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

You can use Hour function to get the hour to add one to it

Hour = Hour([Hora1])

Hour end = Hour([Hora1]) +1

[camargos88]

@Y-Hernandez99P ,

You can use the TIME function and IF.

https://docs.microsoft.com/en-us/dax/time-function-dax

Ricardo