Forum Discussion
Solved
Rolling Count that resets when a row value is zero
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 be...
Hi,
Please kindly check the attached file and the below picture if it suits the requirement.
Thank you.
Hi Jihwan_Kim ,
Many thanks once again!
I have also acheived the same result as you did using your blog (How I create Cumulative Sums that resets whenever value is zero (jihwankimcscp.wixsite.com))
The blog was very helpfull. Thanks once more!
But my chalenge now is to get the (cumulative sum measure with reset) to return max value in each row of the Tax_YearWeek as below;
Please can you help more?
Thanks
Jihwan_Kim
Super User
Super UserHi,
Please kindly check the attached file and the below picture if it suits the requirement.
Thank you.