Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Y-Hernandez99P
Frequent Visitor

¿Cómo puedo comprobar si un campo tipo hora está en un rango de hora?

Buen día, mi pregunta es como puedo comprobar si la columna x está en un rango de hora? por ejemplo, de 3pm a 4pm?

Gracias por leer.

Aquí muestro como están los datos

erre.png

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

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:

Annotation 2020-04-30 141130.png

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!

View solution in original post

3 REPLIES 3
v-kelly-msft
Community Support
Community Support

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:

Annotation 2020-04-30 141130.png

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
Super User
Super User

Puede utilizar la función Hora para obtener la hora para agregaruna

Hora- Hora([Hora1])

Fin de la hora: hora([Hora1]) +1

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
camargos88
Community Champion
Community Champion

@Y-Hernandez99P ,

Puede utilizar la función TIME y IF.

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

Ricardo



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

Proud to be a Super User!



Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors