Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 can easily calculate payroll. I added a new table into Power BI with the different pay periods and created a relationship between the shift start time from the original data and the start date of the new table. I can't figure out how to assign a pay period to each time entry based on the shift start time falling between the correct pay period range. I'm new to Power BI, so please forgive my ignorance if I'm missing something obvious!
Thanks - Pete
Solved! Go to Solution.
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,
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,
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |