Running total of a measure

[Anonymous]

I have 3 measures highlighed in screenshot, I want to calculate running total of a 3rd measure in a last column. I calculated it using quickmeasure - running total over year 

ccUnsolved running total in Year =

CALCULATE(

    [ccUnsolved],

    FILTER(

        ALLSELECTED('MyTicket'[createdate].[Year]),

        ISONORAFTER('MyTicket'[createdate].[Year], MAX('MyTicket'[createdate].[Year]), DESC)

    )

)

However get wrong result. I have ticket create date from which I am showing year and month.

How can I get running total of ccUnsolved measure?

Expected va;lues as shown in highlighed column

[Ashish_Mathur]

Hi,

Create a Calendar Table with calculated column formulas for Year, Month name and Month number.  Sort the Month name column by the Month number.  To your visual, drag Year and Month name by the Month number.  Write this measure

RT = calculate([ccunsolved],datesbetween(caendar[date],minx(all(calendar),calendar[date]),max(calendar[date])))

Hope this helps.

[amitchandak]

@Anonymous , join the date with date of date table and use that in measure and visual

in case date has time stamp create a date first

new column

date = datevalue([created date])

example

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))

Cumm Based on Date = CALCULATE([Net], Window(1,ABS,0,REL, ALL('date'[date]),ORDERBY('Date'[date],ASC)))

Cumm Based on Date = CALCULATE([Net], Window(1,ABS,0,REL, ALLSELECTED('date'[date]),ORDERBY('Date'[date],ASC)))

Running Total/ Cumulative:
https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=42

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc