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 cant figure it out. 

 

Can anyone help me out here please


Best regards 

Petter

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)

4 Replies

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    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

  • alena2k's avatar
    alena2k
    Icon for Resolver IV rankResolver IV
    6 years ago

    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")