Forum Discussion
Anonymous
6 years agoNot applicable
DAX on dates
Hi ,
I have a table whixh is like this
Employee ID, from date, to date, status
1 1 may 2019 30 july 2010 active
I want to calculate all active employees in june but calendar is connected to from date . Active employees is not being calculated for month of june or july ..
Any thoughts
1 Reply
- MattAllington
Community Champion
I wrote an article a few years ago that should help you. It's not the same problem, but the principle is the same. https://powerpivotpro.com/2016/12/how-many-working-days-has-an-employee-been-off-work/