cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
timwilson
Frequent Visitor

Calculate difference in time accounting for business hours

Hi,

 

In Excel I used a formula which determined the time difference between 2 datetimes and returned based on a calendar the number of hours for resolution based on business hours. e.g. 8AM to 8PM is the business hours range and it's from Monday to Friday. If the ticket was raised at 9PM on a Thursday it would only start the counter from 8AM on Friday.

 

Wondering how to do this in PowerBI?

1 ACCEPTED SOLUTION
v-haibl-msft
Microsoft
Microsoft

@timwilson

 

I think your requirement should be almost same as this thread. You should only need to change the business end time. Please try to following the steps listed to see if it works.

 

Best Regards,

Herbert

View solution in original post

2 REPLIES 2
v-haibl-msft
Microsoft
Microsoft

@timwilson

 

I think your requirement should be almost same as this thread. You should only need to change the business end time. Please try to following the steps listed to see if it works.

 

Best Regards,

Herbert

View solution in original post

@v-haibl-msft

 

Thank you, it worked perfectly.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.