Forum Discussion
Solved
Skip Weekends when adding date
I have two column - Start Date and Days required to deliver. So if Start Date is 13/10/2023 which is on a friday and Days required to deliver is 2,so I need a new column called Arrival cut off da...
Please check attached pbix for more details.
Thank you so much!!! this works ,
one more question - how to a set another parameter in the same m query , where there is a column delivery days and its values are
Mon-Fri , Mon-Sat,Mon-Sun,Mon-Thu, Tue-Sat . and skip other days based on these parameters,
So Mon-Sat - skip sunday , mon- thu - skip friday, saturday and sunday.
I didn't quite understand you, show the expected result in Excel
like the calculations that you have done was excluding weekends , so based on the delivery days column it is Mon-Fri, so based on what I set a condition I set for the row value which i set in the backet SQL , that is if column value is x then Mon-Fri if column value is y then Mon-Sat
So if Column value has Mon-Fri skip counting sat and sun , if Mon-Sat skip sunday
your calculation logic is incomprehensible to me
start end days required Delivery days arrival cut-off date 13/10/2023 2 Mon-Fri 17/10/2023 13/10/2023 2 Mon-Sat 16/10/2023 13/10/2023 2 Mon-Sun 15/10/2023 18/10/2023 2 Tue-Thu 23/10/2023