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 need to have a cumulative count of the hired employees [Hired-terminated] in a date table where we have continuous dates available and we should be able to filter the cumulative count by all the dimensions available in the below sample data.
Below is the sample data: I need to take avg. headcount and plot on the line chart and this chart should be filterable by all the possible dimensions in below sample data.
Employee_ID | LegalID | Worker_LOB | Worker_Customer_ID | Hire_Date | Termination_Date | Job_Family_Group |
000958 | LE004 | LOB004 | C005 | 1/22/2001 | Customer Service Group | |
301123 | LE004 | LOB004 | C005 | 1/10/2005 | Customer Service Group | |
300029 | LE004 | LOB004 | C005 | 9/26/2005 | Customer Service Group | |
209392 | LE004 | LOB002 | C002 | 6/28/2010 | 4/30/2020 | Sales Group |
725275 | LE004 | LOB004 | C003 | 9/27/2010 | Sales Group | |
725283 | LE004 | LOB004 | C005 | 9/27/2010 | Customer Service Group | |
728624 | LE004 | LOB002 | C002 | 6/20/2011 | 5/3/2020 | Sales Group |
209855 | LE004 | LOB002 | C002 | 9/19/2011 | Sales Group | |
730567 | LE004 | LOB002 | C002 | 9/19/2011 | Sales Group | |
708177 | LE004 | LOB002 | C002 | 12/2/2011 | Sales Group | |
732951 | LE004 | LOB002 | C002 | 2/24/2012 | 6/15/2020 | Sales Group |
732962 | LE004 | LOB002 | C002 | 2/24/2012 | Sales Group | |
733671 | LE004 | LOB004 | C001 | 4/11/2012 | Sales Group | |
733628 | LE004 | LOB002 | C002 | 4/16/2012 | Sales Group | |
735690 | LE004 | LOB004 | C003 | 7/16/2012 | Sales Group | |
735690 | LE004 | LOB004 | C003 | 7/16/2012 | Sales Group | |
735690 | LE004 | LOB004 | C003 | 7/16/2012 | Sales Group | |
735690 | LE004 | LOB004 | C003 | 7/16/2012 | Sales Group | |
735690 | LE004 | LOB004 | C003 | 7/16/2012 | Sales Group | |
736792 | LE004 | LOB002 | C002 | 10/19/2012 | 1/1/2020 | Sales Group |
737580 | LE004 | LOB002 | C002 | 1/7/2013 | Sales Group | |
766660 | LE004 | LOB002 | C002 | 2/4/2013 | Sales Group | |
739488 | LE004 | LOB002 | C002 | 3/1/2013 | Sales Group | |
734469 | LE004 | LOB002 | C002 | 3/1/2013 | Sales Group |
@Ram_DCT , refer to if my blog on HR can help you
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |