Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Paycor is our payroll service, and we can output a report that has information on each employee for each payroll date.
At it's most basic it will show
Payroll Date : Name : Job Title : Pay for that period of time
Job title is the issue. If an employee gets a changed job title, then all past transactions are changed to that new job title if I run the report today. So, if 3 of our employees changed from Reception to MA as of July 2017, and are now classified as MA when I run the report today, and I want to see what our Receptionist department cost was in June 2017, then those 3 will be missing from the list because they are now classified as MA from now back to the beginning.
I'm sure there exists some system or clever solution to manage this, i'm just not sure what it is or where to start. An suggestions?
So, i'm creating and maintaining a table like this?
Employee number | Employee name | Date | Position |
1 | John Doe | 1/1/2019 | Clerk |
2 | Peter Parker | 1/1/2019 | Clerk |
3 | Daisy May | 1/1/2019 | Reception |
4 | Lexy Ann | 1/1/2019 | Reception |
5 | Jack Black | 1/1/2019 | Manager |
1 | John Doe | 1/2/2019 | Clerk |
2 | Peter Parker | 1/2/2019 | Clerk |
3 | Daisy May | 1/2/2019 | Reception |
4 | Lexy Ann | 1/2/2019 | Reception |
5 | Jack Black | 1/2/2019 | Manager |
1 | John Doe | 1/3/2019 | Clerk |
2 | Peter Parker | 1/3/2019 | Clerk |
3 | Daisy May | 1/3/2019 | Reception |
4 | Lexy Ann | 1/3/2019 | Reception |
5 | Jack Black | 1/3/2019 | Manager |
1 | John Doe | 1/4/2019 | Clerk |
2 | Peter Parker | 1/4/2019 | Clerk |
3 | Daisy May | 1/4/2019 | Reception |
4 | Lexy Ann | 1/4/2019 | Reception |
5 | Jack Black | 1/4/2019 | Manager |
1 | John Doe | 1/5/2019 | Clerk |
2 | Peter Parker | 1/5/2019 | Clerk |
3 | Daisy May | 1/5/2019 | Reception |
4 | Lexy Ann | 1/5/2019 | Reception |
5 | Jack Black | 1/5/2019 | Manager |
1 | John Doe | 1/6/2019 | Clerk |
2 | Peter Parker | 1/6/2019 | Clerk |
3 | Daisy May | 1/6/2019 | Reception |
4 | Lexy Ann | 1/6/2019 | Reception |
5 | Jack Black | 1/6/2019 | Manager |
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!