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
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
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.
You can use Hour function to get the hour to add one to it
Hour = Hour([Hora1])
Hour end = Hour([Hora1]) +1
You can use the TIME function and IF.
https://docs.microsoft.com/en-us/dax/time-function-dax
Ricardo
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
108 | |
108 | |
90 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |