Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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
Solved! Go to 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
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