Forum Discussion
Running Totals Issue
I was able to get it to work using the Admissions date:
Running Total =
CALCULATE (
SUM ( Admissions[Bed Movement] ),
FILTER ( ALLSELECTED ( Admissions[Date] ), Admissions[Date] <= MAX ( Admissions[Date] ) )
)
In the visual, use Admissions[Date]:
I believe what was happening originally in your report is that the automatic (built-in) date table was displaying every calendar date in the visual, instead of just the admission dates. Switching to a custom date table essentially replicated this same behavior in the visual. Thus, the revised DAX references the Admissions[Date] column and not the custom date table. However, it's still important to have a custom date table in your data model: you can create a date slicer and filter on year, quarter, etc., and you can perform time intelligence calculations like YTD more easily.
Yes, this worked to show the correct dates (thank you), however, the table only shows a running total when there is a bed movement value for that funding type/week. I would like the running total to display for every funding type, every week, irrespective whether there has been any movement.
I guess this is a separate issue, being that there is no row to even add a zero value to that week because there is no data in the table.
Thank you again for your help.