Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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