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?
Mikestore_time_query.pbix (45.2 KB)