Backward scheduling based on working time DAX

Dear lbendlin  ,

Thanks for the links. I hope I have taken all the hints into account now.

I have been looking for a similar discussion on my topic in this forum for quite some time - unfortunately without success so far.

Based on the Delivery-Date of the Order-Table, the Completion-Dates for the respective Job are to be scheduled backward based on the needed Time for every Job. In addition, scheduling should take into account working hours and weekends.

I already have a simple scheduling based on days and without considering working hours and weekends (Code below) - Thanks to @tamerj1 . 

lbendlinPlease let me know if I have understood the hints in the links correctly and this is the right way to post 🙂

It would be great if someone could help me.

Thanks a lot in advance!

Here is the Sample file in .pbix-format, the Basic-Data as .csv and .xlsx-format.

PowerBI_Community

Also in the following the Relationships:

The expecting Result for the Compleation-Date for Order.No 111 should be: