Countrows where time is after value

Anonymous — Mon, 06 Jul 2020 15:28:41 GMT

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

Re: Countrows where time is after value

amitchandak — Mon, 06 Jul 2020 17:09:57 GMT

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

topic Countrows where time is after value in DAX Commands and Tips

Countrows where time is after value

Re: Countrows where time is after value