Cumulative Total

Hi Libin7963 ,

Once try this:

On Hand Cumulative Total :=
VAR CurrentDate = MAX('DimDate'[Date])
RETURN
SUMX(
    FILTER(
        ALL('DimDate'),
        'DimDate'[Date] <= CurrentDate
    ),
    VAR LoopDate = 'DimDate'[Date]
    RETURN
        CALCULATE(
            COUNTROWS(
                FILTER(
                    Table1,
                    Table1[ValidDate] < LoopDate &&
                    (
                        ISBLANK(Table1[DecisionDate]) ||
                        Table1[DecisionDate] >= LoopDate
                    ) &&
                    Table1[Type] IN {
                        "01", "02", ..., "18"
                    }
                )
            ),
            CROSSFILTER('DimDate'[Date], Table1[ValidDate], None)
        )
)