Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want to create a table with how many employees are available to work each day. I have a table with all the dates:
Calendar Relative = CALENDAR( TODAY()-3650, TODAY()+3650 )
I have another table with all employees listed as well as their starting date and ending date (10 years in the future if they are employed ongoing)
I have a column with the following DAX, but I know this isn't quite what I need.
Hi, @DJTentman
You can try the following methods.
Sample data:
Measure =
CALCULATE ( COUNT ( 'Table'[Employee ID] ),
FILTER ( ALL ( 'Table' ),
[Start Date] <= SELECTEDVALUE ( 'Date'[Date] )
&& [End Date] >= SELECTEDVALUE ( 'Date'[Date] ) ) )
+ CALCULATE ( COUNT ( 'Table'[Employee ID] ),
FILTER ( ALL ( 'Table' ),
[Start Date] <= SELECTEDVALUE ( 'Date'[Date] )
&& [End Date] = BLANK () ) )
Hope this method helps you.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This makes a lot of sense. Thanks. I ended up with this formula:
@DJTentman , refer to the blog or attached files
Thanks, that's been helpful. So, I'm trying to create the number of employee/days per week for each date in the list. This is the DAX I'm using:
User | Count |
---|---|
40 | |
26 | |
22 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |