Forum Discussion

Petter120's avatar
Petter120
Icon for Helper I rankHelper I
6 years ago
Solved

If time value is between two other time values

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...
Need Help
  • AlB's avatar
    AlB
    6 years ago

    Hi Petter120

    If Table[Column1] is what you want to check:

    Table1[Column1] > TIME(10,00,00) && Table1[Column1] <= TIME(10,59,59)

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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