Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Puede utilizar la función Hora para obtener la hora para agregaruna
Hora- Hora([Hora1])
Fin de la hora: hora([Hora1]) +1
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |