Running total of a measure

[spoony]

I have a table - Data, with columns:

Year - Date type

Sales - Whole number

Cost - Whole number

I created a measure for Profit = Table[Sales] - Table[Cost]

How do i put the measure "Profit" in this following running total formula. It doesn't show the measure as an input on the Sum function:

Running Profit COLUMN = CALCULATE (

SUM ( 'Profit' ), 

ALL ( 'Data' ),

'Data'[Year] <= EARLIER ( 'Data'[Year] ) )

[Phil_Seamark · Accepted solution]

Hi @spoony

This might be close to what you need, and it doesn't rely on your other measures.

Running Total Column = SUMX(
        FILTER(
                'Table1',
                'Table1'[Year]<=EARLIER('Table1'[Year])
                ),
           'Table1'[Sales]-'Table1'[Cost])

[spoony]

Thanks phil, its kinda working. My filter on one of the columns of this table is causing it to not work so i have to look into.

[Phil_Seamark]

ok, feel free to post back here if you need more help 🙂