We have the following table with Request ID, date time value on when it was created and when it was resolved, and we need to calculate the hours it takes for each request to be completed.
Our team works from 8 AM to 5 PM, Monday to Friday.
This is a common scenario in Power Platform consulting, where businesses need to track working hours efficiently within Power BI.
Our Power Platform consulting services provide a comprehensive approach to identifying process enhancement opportunities within Power BI, ensuring your business achieves optimal efficiency through expertly crafted solutions. Reach out to us to see how we can transform your operations today.
First, make sure you create a calendar table for your data, for simplicity I created one from 1/1/2021 to 12/31/2022.
Add the following calculated columns in your Calendar Table
This is how your calendar table should look
Now, go back to your transactions table and add a calculated column
This how your table should look:
Find the file used for this post here.
You’re all set! Short and pretty, right?
