Forum Discussion

az12's avatar
az12
New Member
3 years ago
Solved

Time Comparison gives wrong answer

Hi,   I'm trying to filter my data (telephone calls events) to only include calls that take place during work hours. Unfortunately the conditional statement I'm using returns the wrong answer from ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    az12 Can't replicate this. Try this though:

    Call During Working Hours = IF( ('EVENT'[Local Start Time] - TRUNC('EVENT'[Local Start Time]) ) <= ('EVENT'[Working Day Closing Time] - TRUNC('EVENT'[Working Day Closing Time]) ),1,0)
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Cannot spot a mistake in the formula.  Ensure that the formula is a calculated column formula (not a measure).  If it still does not help, then share the download link of the PBI file.