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

Calculate Business Hour TAT including half day saturdays

Hi, Im new on power bi and i need help with calculating a queries TAT. If one works between 8am and 5pm weekdays and 8am till 12pm on a saturday excluding sundays. Is there a way i can calculate the TAT of a query excluding as well the time when one is is not working?

 

Query Number                       Received_Time                    CompletionDate                     Status Turn       Around Time

12                                           21-06-2019 14:00                24-06-2019 10:00                Completed             9 hours

 

The above example shows a query that was logged on friday at 2pm. This means it should only calculate 3 hours for that day, then start counting on the saturday at 8am till 12 (add 4 hours) and continue counting on the monday till 10 am (2 hours).

2 REPLIES 2
Super User
Super User

Re: Calculate Business Hour TAT including half day saturdays

Perhaps look at using something like GENERATE. 
Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Highlighted
atari35 Frequent Visitor
Frequent Visitor

Re: Calculate Business Hour TAT including half day saturdays

Hi Greg,

 

Thank you for your reply. The generate function, does it also work with time? The examples you gave me are for date ranges and im looking to calculate by time

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)