Forum Discussion
Headcount
Hello, I am needing some assitance with finding out headcount data broken down weekly, monthly, annually. I have two data tables: US_CORE_HR (bi-weekly hr data) and a calendar table which has the...
V-lianl-msft
Community Support
Community SupportHi Anonymous ,
Here is a good blog to solve this problem, please refer to:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you, but this does not work for my data set. I have read through that article already. The main difference is their employee data file is stationary, meaning it does not included historical data in the cadence of pay periods. It I worked with just one payroll file it would work. However, I work with a file that includes each pay periods data. This allowes me to caputer historical data week over week.