topic Re: Dax support to calculate working days between two dates in DAX Commands and Tips

Dax support to calculate working days between two dates

Anonymous — Tue, 17 Nov 2020 17:53:11 GMT

I have a requirement to calculate the number of working days within the two given columns as "Date of Join" and "Date of Resign" of the Employee table. Since I have a requirement to have a month-wise breakdown of workdays based on the employees using filters in the visualization. How can I implement it without using calculated columns? as it will not dynamically change the values during the runtime

I have a Date table with boolean values for the working days.

Re: Dax support to calculate working days between two dates

Fowmy — Tue, 17 Nov 2020 18:46:17 GMT

Anonymous

Your requirement is not clear, however, it is possible to calculate the working day between two dates. provide sample data ad the expected results from it.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube LinkedIn