I need some help with a DAX formula that can capture the balance of rollover hours per day. Example data below is below.
On the first day 10 hours of work was assigned but only 5 hours were completed, resulting in a 5 hour balance. The next day 20 hours of additional work was assigned and 10 hours were completed, which results in 10 hours for that day plus 5 from the previous day. I'm looking for a DAX formula that would do this calculation in the Rollover Balance column. I believe I need to use the EARLIER function but I cant seem to get it right.