Year to Date Rolling Total

[Anonymous]

Good Day,

I am trying to get a running total by year but am just getting the total of each year. What I am wanting is a running total by year. So for instance 2018 has 1085 as the count and 2019 has 12404 as the count on the matrix I would like 2019 to be a sum of 2018 & 2019 and to continue on for the rest of the years. Can someone help me through this madness? 

Current Formula: 

YTD Assets =

CALCULATE (

  SUM (Assets[Status Bit]),

    FILTER (

        ALL ( 'Assets' ),

        'Assets'[Created_Date] <= MAX ( 'Assets'[Created_Date] )

            && 'Assets'[Year] = MAX ( 'Assets'[Year] )

    )

)

Many Thanks,

Your friendly neighborhood Lydia

[Anonymous]

@Greg_Deckler Thank youuuuu!!!! It worked!!

[Greg_Deckler · Accepted solution]

@Anonymous Try Better Running Total: Better Running Total - Microsoft Power BI Community

Better RT = 
    VAR __Date = MAX('Assets'[Created_Date])
    VAR __Table = FILTER(ALLSELECTED('Assets'),[Created_Date] <= __Date)
RETURN
    SUMX(__Table,[Status Bit])