Persisting a Running Total

amitchandak Yes, the running totals are both calculating properly, as demonstrated in the table in both screen shots. There is also a date table marked properly and joined. The issue is that its two different series of data, so even though they're joined to the same date table, the series don't "persist forward" past their last date. Now I could go back in the date hierarchy to "month" or "quarter" or "year" but then the problem becomes that you still have to have data at that "scale". If one series only has data in January and the other series has data that carries forward to November and you only drill down to quarter, you would still have the same dilema. I want/need to be able to say value "X" (the running total) persists forward for all dates, even though there are no rows of data in the fact table driving that persistence.

I hope that makes sense.