Forum Discussion

DWestman's avatar
DWestman
Copper Contributor
Mar 14, 2023

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

Resources