Forum Discussion
DWestman
Mar 14, 2023Copper Contributor
How to create a rolling calculated column in sharepoint list
Hi- first time posting here, and new to sharepoint.
I have a sharepoint list in which i have some basic calculating columns totaling hours and units worked on a day's shift per employee. I was looking for some insight, if a calculated column could be made using a rolling time calculation for instance towards a payroll date. This will allow me to group all entries by a pay date. payroll is sent out on the 15 & 30th of every month.
I plan to have this sharepoint list as a data source into power bi & /or excel i can easily group the employee's total per pay period and have it vlookup again a payment table. However if i can group by a payment period that would greatly impact my over all goal.
Thank you for taking to time to review my question
Drew Westman
No RepliesBe the first to reply