Forum Discussion

pvanolinda's avatar
pvanolinda
Frequent Visitor
10 years ago
Solved

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...
  • v-sihou-msft's avatar
    10 years ago

    pvanolinda

     

    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,