topic Re: Year to Date Rolling Total in DAX Commands and Tips

Year to Date Rolling Total

Anonymous — Mon, 31 Oct 2022 21:16:17 GMT

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

Re: Year to Date Rolling Total

Greg_Deckler — Mon, 31 Oct 2022 21:29:25 GMT

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])

Re: Year to Date Rolling Total

Anonymous — Tue, 01 Nov 2022 14:04:12 GMT

Greg_Deckler Thank youuuuu!!!! It worked!!