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