count the number of orders

[mina97]

i have the following data 

date/time	type
19/9/2023 16:10:02	A
20/2/2023 16:10:02	B
20/2/2023 9:00:11	B
20/3/2023 12:22:34	A

i want the orders that comes after duty hours which is 7:00:00 to 15:00:00 to be included with the day after 

so the order number 2 should be summed with the orders on  20/3/2023 because it came on 16:10:02 which is after 15:00:00

please helo and thank you 

[wdx223_Daniel]

=CALCULATE(DISTINCTCOUNT(Table[Type]),FORMAT(Table[date/time]+TIME(9,0,0),"yyyyMMdd")="20230320")

[mina97]

hi i appreciate your help please check this out for clearity

what's the desired output?Count orders per day? yes count the orders py day with a condition which " if order came between the time  7:00:00 to 15:00:00 count it as today's orders if not count it with tommorrows orders. i hope it is clear

What do you do for the first order which is also outside your time range? the time range starts from 1/june/2018 and ends at today's date no matter what date is it today i need it to be automatically linked with today.

THANK YOU FOR CONSIDERATION and please help

[Dangar332]

Hi, @mina97

i am take these example

add column 

newtime = IF('Table'[time]>TIMEVALUE("15:00:00"),1,0)

and

newdate =

var currentdate = 'Table'[date]

var nextdate = MINX(FILTER('Table','Table'[date]>currentdate),'Table'[date])

var final = IF('Table'[newtime1]=1 &&  nextdate=BLANK() ,TODAY(),IF('Table'[newtime1]=1,nextdate,'Table'[date]))

return final

after adding two column it look llike these

put newdate and order to table 

• Did i answer your question? Mark my post as a solution which help other people to find  fast and easily.