Forum Discussion

android1's avatar
android1
Post Patron
10 years ago
Solved

Comparing Date/Time Columns

Hi,   I have 4 Date/Time columns->[ShiftInTime] [ShiftOutTime] [TimeFrom] [TimeTo] I am trying to count the total number of times [ShiftInTime] & [ShiftOutTime] is equal to [TimeFrom] & [TimeTo] (...
Need Help
  • sdjensen's avatar
    sdjensen
    10 years ago

    Try this formula instead:

     

    IF( Query1[ShiftInTime] = Query1[TimeFrom] && Query1[ShiftOutTime] = Query1[TimeTo], TRUE(), FALSE())
  • Anonymous's avatar
    Anonymous
    10 years ago

    android1 You also probably don't even need this calculated column. You should be able to use a measure instead.

     

    Count Clocked In By Office = CALCULATE(

    COUNT(Query1[WhateverColumnYouWantToCount]),

    FILTER(Query1,

    Query1[ShiftInTime] = Query1[TimeFrom] && Query1[ShiftOutTime] = Query1[TimeTo]))

sdjensen's avatar
sdjensen
Solution Sage
10 years ago

Try this formula instead:

 

IF( Query1[ShiftInTime] = Query1[TimeFrom] && Query1[ShiftOutTime] = Query1[TimeTo], TRUE(), FALSE())
  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    android1 You also probably don't even need this calculated column. You should be able to use a measure instead.

     

    Count Clocked In By Office = CALCULATE(

    COUNT(Query1[WhateverColumnYouWantToCount]),

    FILTER(Query1,

    Query1[ShiftInTime] = Query1[TimeFrom] && Query1[ShiftOutTime] = Query1[TimeTo]))

    • android1's avatar
      android1
      Post Patron
      10 years ago

      Both solutions work perfectly. Best not to use a calculated column if at all possible.

      Thanks a million.