Finding Target Due Date for business hours

[Anonymous]

Hi guys, I want to create new column which is 'Target Due Date' in 'Schedule Table'. This column should return date where task should be done based on priority. (need to consider only working hours and non-Holiday day).
2 tables: BusinessCalendar, Schedule (images below)

Working hours should be 8.30 am - 5.30 pm.
Priority: Low=14 hours

For example. I got assigned a task on 11/6/2021 1:45:00 PM, priority Low, 12/6/2021 and 13/6/2021 are weekend, 14/6/2021 is public holiday. So, target date should be 16/6/2021 9:45:00 AM

BusinessCalendar tableSchedule tableexample

[lbendlin]

What is your required level of precision. Is 15 minutes enough or do you need better precision (5 minute or single minute for example).  Your answer will impact the size of the tables that will be used in the INTERSECT operation.

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523