March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
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
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |