Forum Discussion

BrettM's avatar
BrettM
Frequent Visitor
2 years ago
Solved

Previous Days Orders

We have a eComm program in place where we ship all orders received by 2 PM same day.  This means when looking at orders the timing for "Today's orders needs to be calculated from 2:01 PM yesterday to...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi BrettM ,

     

    You can try below formula:

    FilteredOrders = 
CALCULATETABLE (
    VALUES ( 'YourTable'[OrderID] ),
    FILTER (
        'YourTable',
        'YourTable'[OrderTimestamp]
            >= NOW () - 1
                + TIME ( 14, 0, 0 )
            && 'YourTable'[OrderTimestamp]
                < NOW () - 1
                    + TIME ( 14, 0, 0 ) + 1
    )
)

     

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

BrettM , Create a new date column  using your date time column

 

Date 1 = if(Timevalue([DateTime]) > Time(14,0,0) , Datevalue([DateTime])+1, Datevalue([DateTime]))

BrettM's avatar
BrettM
Frequent Visitor
1 year ago

I may have not explained it well.  Any orders received in the below-mentioned "Days/Hours Received" would belong to the "Processing Days". Example of how they are to be treated below. 

 

Processing DaysDays/Hours Received
MondayFriday - 1:30 PM - Monday 1:29 PM
TuesdayMonday - 1:30 PM - Tuesday 1:29 PM
WednesdayTuesday - 1:30 PM - Wednesday 1:29 PM
ThursdayWednesday - 1:30 PM - Thursday 1:29 PM
FridayThursday - 1:30 PM - Friday 1:29 PM