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),
'Fulfillment'[Status] IN {"Awaiting Response","In Progress","Routed","Unresolved"})

 

 

 

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

1 Reply

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