if order after 15:00:00 considers as new

[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 

[Anonymous · Accepted solution]

Hi @mina97 ,

Consider adding a custom colum in powerquery:

if Time.Hour([#"date/time"]) > 15 then Date.From(Date.AddDays([#"date/time"], 1)) else Date.From([#"date/time"])

Output:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum