Forum Discussion
TariSurion
5 years agoRegular Visitor
Calculate working days
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 t...
- 3 years ago
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/
daxer-almighty
Solution Sage
5 years agoOf 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.