Forum Discussion
Ronald123
5 years agoResolver III
Dynamic calculation workingsdays
Hello, I need a measure to calculate the workingsdays dynamic based on a condition. This condition is based on a slicer. Please take a look @ the test file with the expected results. Gree...
- 5 years ago
Hi Ronald123 ,
There is a detailed blog on this on how you can calculate working days using start date and end date:
https://blog.enterprisedna.co/calculate-workdays-between-two-dates-in-power-bi/
Thanks,
Pragati
Ronald123
5 years agoResolver III
Pragati11
My bad, i don't know how to implement below condition in the code from the blog.
Could you help me to make the measure in the test file?
Greets,
Ronald
Variable condition
END DATE IF ( Date Slicer < END DATE then SLICER else END DATE