Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Time Comparison in Filter expression not working

I have a simple table that looks like this... Time ID Number Baseline 12:00 AM 001 123 1:00 AM 001 256 11:00 PM 001 269 12:00 AM 002 796 1:00 AM 002 456   The time...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    3 years ago

    I meant there are no rows between 1:00 PM and 3:00 PM in the sample data you provided in your original post.
    Is your time column set to time data type in your model?  The measure works as expected on the sample you provided.

     

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
3 years ago

Anonymous 

Try it like this.

Time Amount =
CALCULATE (
    SUM ( 'Table'[Baseline] ),
    'Table'[Time] >= TIME ( 13, 0, 0 ) && 
    'Table'[Time] <= TIME ( 15, 0, 0 )
)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

jdbuchanan71 

Thank you for the answer. However, it comes out empty.