How to create a running total that will flatline once no more data
My goal is to go from Picture 1 to Picture 2(below). I have 3 calculations for the running totals. My challenge is with the yellow line. The yellow line calculations does not stretch to the final year and I want it to be able to flatline to the end.
My DAX calculation for the yellow line is like so:
This^ calculation works great for calculating the running total, except it stops once there is no data. I want it to do what is shown in Picture 2 - to strech til the end. Does anyone know how to accomplish this? Thanks!