DAX: S-Curves, or cumulative counts

21 Mar, 2025

This can be used for project S-Curves.

S-Curve Quantity = 
VAR thisDate = MAX('Calendar'[Date])

RETURN
CALCULATE(
    [Quantity],
    FILTER(
        ALLSELECTED('Calendar'),
        [Date] <= thisDate
    )
)

#dax #powerbi