Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Helper III
Helper III

how to make old sales considered as new

i have the following data 


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


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 

Community Support
Community Support

Hi @mina97 

Can you provide some more information and the expected output you want, i am confused that how to add the order.


Best Regards!

Yolo Zhu

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors