Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Countrows where time is after value

I'm trying to countrows with a measure where the date created is after 1300, DateCreated is Date/time   SumAfter1300 = CALCULATE(COUNTROWS('Fulfillment'), 'Fulfillment'[DateCreated]>TIME(13,0,0)...
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , what is date you need

    example one

    SumAfter1300 = CALCULATE(COUNTROWS('Fulfillment'),
    'Fulfillment'[DateCreated]> today()+ TIME(13,0,0),
    'Fulfillment'[Status] IN {"Awaiting Response","In Progress","Routed","Unresolved"})

     

    or Time > time

    SumAfter1300 = CALCULATE(COUNTROWS('Fulfillment'),
    'Fulfillment'[DateCreated].Time> TIME(13,0,0),
    'Fulfillment'[Status] IN {"Awaiting Response","In Progress","Routed","Unresolved"})

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , what is date you need

example one

SumAfter1300 = CALCULATE(COUNTROWS('Fulfillment'),
'Fulfillment'[DateCreated]> today()+ TIME(13,0,0),
'Fulfillment'[Status] IN {"Awaiting Response","In Progress","Routed","Unresolved"})

 

or Time > time

SumAfter1300 = CALCULATE(COUNTROWS('Fulfillment'),
'Fulfillment'[DateCreated].Time> TIME(13,0,0),
'Fulfillment'[Status] IN {"Awaiting Response","In Progress","Routed","Unresolved"})