Help with running total

Hi aagj ,

At first, you need to create a new column to get "YYYY-MM".

YM = 
FORMAT('Table'[Date],"yyyymm")

Then you could use column or measure to get the running total.

Column:

Column =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    FILTER (
        'Table',
        'Table'[YM] = EARLIER ( 'Table'[YM] )
            && 'Table'[Date] <= EARLIER ( 'Table'[Date] )
    )
)

Measure:

Measure =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[YM] = MAX ( 'Table'[YM] )
            && 'Table'[Date] <= MAX ( 'Table'[Date] )
    )
)

 Here is my test file for your reference.