Forum Discussion
pvanolinda
10 years agoFrequent Visitor
Pay Period for Time Clock App
I've imported data into Power BI from a SharePoint app we use for time tracking. It consists of shift start & end times for staff. I need to mark each item with a pay period so our accounts person ca...
- 10 years ago
Do you mean that the pay period depends on the shift start time? And you want a new “pay periods” column to be added into the original table?
If so, I assume you have one original table and one new table as below. You can create a many to 1 relationship between them. Then put a table chart in your canvas and select four columns for it as below.
Regards,
v-sihou-msft
10 years agoMicrosoft Employee
Do you mean that the pay period depends on the shift start time? And you want a new “pay periods” column to be added into the original table?
If so, I assume you have one original table and one new table as below. You can create a many to 1 relationship between them. Then put a table chart in your canvas and select four columns for it as below.
Regards,