Calculate Completion Date based on work hours

[learner03]

I need to calculate completion datebased on following-

Total Shift Hours per person=7.5

Shift Sart time=7:00am

To calculate completion date= if total time taken in less that total shift hours, then completion day will be same day as start day. Otherwise, calculate based on shift hours as 1 day=7.5 (exclude weekend).

[Anonymous]

Hello! It is as link for download my solution https://cloud.mail.ru/public/Uv2r/VrHxq3fB4

[grantsamborn]

Hi @learner03 

You might want to look at this:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculation-of-the-process-completion-datetim...

or this

https://www.youtube.com/watch?v=2HkBbqxBzF0

Maybe @lbendlin  would be able to help.

[learner03]

@grantsamborn I saw this solution but cannot get how the start and end helper are added and a few more things. I have send a message as a reply in that post ...waiting for @lbendlin to respond.

Thanks

[grantsamborn]

@learner03 

How about his?

https://community.powerbi.com/t5/Desktop/How-to-add-time-to-working-days-with-its-working-hours-excl...

(I think it's interesting that a question like this doesn't come up more often.)

[learner03]

I tried this solution, but no luck. The answers are not correct.

@Anonymous Can you please help?