Dax support to calculate working days between two dates

[Anonymous]

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.

[Fowmy]

@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