I’m looking to add a calculated column to my below scenario. The basic premise, is I need to 1) Determine how many days in a row an employee worked and 2) Cumulative hours based on the cumulative days.

I found a formula for a calculated column for adding the cumulative days on the MS Power BI forum which is working exactly as I need but I’m struggling to accomplish the next step of cumulative hours.

I’ve attached a .pbix file with sample data along with the formula for the cumulative days count.

Hi @mvgust, did the response provided by @jbressan help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

Hi @mvgust, we’ve noticed that no response has been received from you since the 30th of March. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.