Forum Discussion
Running Total Using a Date Input
Hi, I am trying to create a Line and Clustered Column Chart to represent actual and outstanding cumulative values (Line) and period values (Clustered Columns) for a dataset. The shared axis repr...
COBRIEN , Try like
Actual Cumulative =
IF(max(Table[Week Ending])>=today(),BLANK(),
CALCULATE(SUM(Table[Actual Period]),
FILTER(
ALLSELECTED(Table[Week Ending]),
ISONORAFTER(Table[Week Ending],MAX(Table[Week Ending]),DESC)
)
))
Outstanding Cumulative =
IF(max(Table[Week Ending])<=today(),BLANK(),
CALCULATE(
SUM(Table[Outstanding Period])+SUM(Table[Actual Period]),
FILTER(
ALLSELECTED(Table[Week Ending]),
ISONORAFTER(Table[Week Ending], MAX(Table[Week Ending]), DESC)
)
))
Thanks for the reply, unfortunately this did not seem to solve my problem.