Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.