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
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).