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.
Hi,
I have a table employees with two relevant fields start and end.
I have a line chart showing the numbers of new and leaving employees per month over a year. I am looking to add a thind line showing the number of employees employed on the last day of each of those months.
Anyone help me with this?
Solved! Go to Solution.
You may refer to the following measure.
Measure = VAR d = MAX ( 'Calendar'[Date] ) RETURN CALCULATE ( DISTINCTCOUNT ( Table1[employeeId] ), FILTER ( Table1, Table1[start] = d ) ) + 0
You may refer to the following measure.
Measure = VAR d = MAX ( 'Calendar'[Date] ) RETURN CALCULATE ( DISTINCTCOUNT ( Table1[employeeId] ), FILTER ( Table1, Table1[start] = d ) ) + 0
Create a table with the end dates for each month. Add a calculated column where you COUNT or COUNTROWS the number of rows that have an end date less than that month. Something along those lines should work.
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |