topic Re: Calculate working days in DAX Commands and Tips

Calculate working days

TariSurion — Tue, 08 Dec 2020 10:24:41 GMT

Hey all,

I have an issue with DAX and hope you can help me.

I have a list of support tickets. All of them have a send-in date and time. Some are already solved, so they have a closing date and time. The tickets that are still open have no data in the "Closed" column.

I want to calculate how long these tickets have been open or how long they are open right now. But, I only want to count the working days. Is there a way to calculate this?

It would be very nice if it's possible to also count the hours. So when a ticket has been open for3 (working) days and 12 hours, the result will be 3.5.

Thanks!

Marieke

Re: Calculate working days

daxer-almighty — Wed, 09 Dec 2020 14:26:58 GMT

Of course, it's possible because almost everything in DAX is possible (apart from recurrence unless it's sidways). However, to calculate in DAX you have to have a good and correct model. Please read this to know how to construct correct models. Once you have such a model, you can show it to us and we'll try to give you a solution.

Re: Calculate working days

technolog — Mon, 04 Sep 2023 17:15:36 GMT

Hey! you can use one of this approach:

https://community.fabric.microsoft.com/t5/Desktop/workday-DAX-in-power-bi/m-p/2748111#M957141

https://www.sqlbi.com/articles/counting-working-days-in-dax/