Without seeing your date dimensions my best guess would be to add an If statement to check the day of the week
Something like > IF DATENAME('weekday',[Order Date])='Monday' then (here put in your statement to look back 2-days value)
Else (here put in the statement you use above) End
Let me know if this helps
Yes Jim, One more point to add here..If there is a blank in the 5 days during the week then you need to include for that too in formula.
Right you are
your formula should work as you expected. I just create a sample workbook and put your formula(Red line) you provided and show the result as below.
All the missing rate in blue line shows in the red line from its previous value.
I guess may be the way of data is different. If you could provide a make up workbook with just couple of records to indicate the issue would be more helpful to investigate.
sample.twbx 13.2 KB