Forum Discussion

Febin's avatar
Febin
Frequent Visitor
3 years ago
Solved

TOTALYTD Giving same value as the source column

Hi,   I'm trying to create a simple running total column for the values in "Distance Travelled". My fomula in the column "RunningTotl" is as follows:     I'm having a separate date table "...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    3 years ago

    Ok. for the calculated column:

    Running total by Year =
VAR _Year =
    YEAR ( fTable[date] )
RETURN
    CALCULATE (
        SUM ( fTable[Value] ),
        FILTER (
            fTable,
            fTable[date] <= EARLIER ( fTable[date] )
                && YEAR ( fTable[date] ) = _Year
        )
    )

     

    As a measure

    the model:

    YTD measure = 
TOTALYTD(SUM(fTable[Value]), 'Calendar Table'[CalDate])

     

PaulDBrown's avatar
PaulDBrown
Community Champion
3 years ago

Ok. for the calculated column:

Running total by Year =
VAR _Year =
    YEAR ( fTable[date] )
RETURN
    CALCULATE (
        SUM ( fTable[Value] ),
        FILTER (
            fTable,
            fTable[date] <= EARLIER ( fTable[date] )
                && YEAR ( fTable[date] ) = _Year
        )
    )

 

As a measure

the model:

YTD measure = 
TOTALYTD(SUM(fTable[Value]), 'Calendar Table'[CalDate])

 

Febin's avatar
Febin
Frequent Visitor
3 years ago

Hi, Thank you very much!!

  • It worked!