Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello there,
Trying to count the number of employees at a given date in the past with the condition that their termination date needs to be either in future or value should be blank.
For Active employees on date or range, you need to make sure the join with the dates is not there.
When a range is selected in the slicer
Active employee = Var _start_date=(minx('Date','Date'[Date])) Var _end_date=(maxx('Date','Date'[Date])) return Active Employee calculate(count(employee_id),filter(employee, Hire_date<=_end_date && terminate_date >=_end_date, CROSSFILTER(employee[Hire_date],date[date],None), CROSSFILTER(employee[terminate_date],date[date],None) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |