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 would like to count the number of active employees in a given period. In the end we wannt to analyse if the company is more productive (revenue divided by total hours or number of employees) after growing or before growing (they have gone from 9 employees to 19 employees mid 2019).
I have a facttable: FactHarvest which is a table where employees fill in their time registration, it looks like this:
Date - Hours - Client - Project - Task - Type - Name Employee - Billable - Billable rate - billable amount - Cost rate - Cost amount
And I have a dim table with all of the employees
Is there a way to count the number of employees and get theem on a graph and see when the number of employees have grown?
Solved! Go to Solution.
The solution to my problem was actually really simple in the end. I fixed part one with following formula 😅
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 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |