Conditional Index

Hi,

Please check the below picture and the attached pbix file.

Actual CC =
VAR _startdate =
    MIN ( Data[Date] )
VAR _startnumber =
    MAX ( Data[Planned] )
VAR _conditiontable =
    ADDCOLUMNS ( Data, "@condition", IF ( Data[State] = "Closed", -1 ) )
VAR _cumulatecondition =
    SUMX (
        FILTER ( _conditiontable, Data[Date] <= EARLIER ( Data[Date] ) ),
        [@condition]
    )
RETURN
    _startnumber + _cumulatecondition

Anonymous this is another alternative, but Jihwan_Kim solution is also great.

Actual CC = 
VAR _startnumber =
    MAX ( Data[Planned] )
VAR _minus_count =
    COUNTROWS(
        FILTER(
            Data, 
            Data[Planned] >= EARLIER(Data[Planned]) && Data[State] = "Closed")
    )
VAR _result = _startnumber - _minus_count
RETURN
    _result

      

Showcase Report – Contoso By SpartaBI