Hello,
Please could you help me to calculate the rolling count of a column (~Category1 No) in AGG_Worked_Hours table; such that when the value is 1, it will do a rolling count but once the value become 0, it will reset count to 0 and start counting the rolling again. This process would continue as a loop untill the end of the data.
This should be able to return the rolling count of each row as below when an Employee_ID is selected from Dim_Employee table.
I have attched the pbi file and sample dataset.
Many thanks for your help!
Sample Dataset.pbix (1.5 MB)
WeekName.csv (95 Bytes)
AGG_WORKED_HOURS.csv (9.0 MB)
DIM_EMPLOYEE.csv (69.0 KB)
DIM_TIME_WORKED_HOURS.csv (19.0 KB)
