Forum Discussion
Working days calculation
Hey Guys im tring to work out the amount of working days and hours bewteen two days for our service level power BI. here is an example of the table in working with, Also with a Close date as null ( due to status) I want to calculate the amount of working days and Hours between open date and "Todays date"
Thanks all Dan
| Ticket Number | Status | Open Date | Close date | Amount Working days and Hours |
| 123456 | open | 27/02/2023 2.00pm | Null | |
| 654321 | closed | 28/02/2023 3.00pm | 28/20/2023 4.00pm | |
| 987654 | closed | 01/03/2023 1.00pm | 02/03/2023 2.00pm |
1 Reply
Hello DanielHolland ,
check if this video works for your case https://youtu.be/6JA6uy3ZRBA
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
