Hi, @MudassirAli@Harsh Now I have more challenge with the one I created yesterday, we need to add store open time for each row. I can add 9:00AM as store open time for each order in Power Query. Now my question is how I can compare the order submission time with store close and open time. I need to flag those orders if the submitted time falls between one hour before store close and store open time (in this case, every orders that were submitted between 8:00PM a to 9:00AM), Can we do that in PowerBI?
I’m also attaching the PBIX file of the working for the reference.
Quick Note: In the data, I’ve observed that none of the orders were placed before 9:00 AM but there are 2 orders placed after 9:00 PM and both of them are highlighted in “RED” color. So if you’ve data where orders were placed before 9:00 AM the formulas in the file will provide you the results accordingly.
Hoping you find this useful and meets your requirements that you’ve been looking for.
@Mike
I added another custom column in Power Query so now one shows the orders during Operating Hours (OH) and the other after OH. You can name the column as per your requirement. I don’t think it is possible to do it in one column due to time range intersection. I used the following code to make it work.
@MudassirAli@Harsh Thank you both for your time and help. I will download the files and try to understand how you guys did. I hope I can easily implement those suggestions you guys gave.
Hi @Mike, did the response provided by the experts help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!
A response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!
