The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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/
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
7 |