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.
Hi i have a column that has a time value for example 10:05:22 (hh:nn:ss).
I am trying to figure out how to use an if statement that tests if the time value is between 10:00:00 and 10:59:59 but i cant figure it out.
Can anyone help me out here please
Best regards
Petter
Solved! Go to Solution.
Hi @Petter120
If Table[Column1] is what you want to check:
Table1[Column1] > TIME(10,00,00) && Table1[Column1] <= TIME(10,59,59)
Hi @Petter120
If Table[Column1] is what you want to check:
Table1[Column1] > TIME(10,00,00) && Table1[Column1] <= TIME(10,59,59)
hi! if you can do it in power query then I would use conditional column:
= Table.AddColumn(#"Prev Table", "Flag", each if ([Time] > #time(10, 0, 0) and [Time] < #time(11, 0, 0)) then "Yes" else "No")
if it is indeed inside one our, there is Start of the Hour option:
= Table.AddColumn(#"Prev Table", "Flag", each if Time.StartOfHour([Time]) = #time(10, 0, 0) then "Yes" else "No")
Hi @Petter120
there is not enough information.
There are could be a lot of solutions. At the first sight:
1. DATESBETWEEN() DAX function https://docs.microsoft.com/en-us/dax/datesbetween-function-dax
2. IF ([Column] >= TIME(10,0,0) && [Column] <= TIME(10,59,59), true(), false())
3. if(HOUR([Column]) = 10, true(), false())
The appropriate solution will depend on your business logic
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
98 | |
81 | |
72 |