Cumulative sum zero values should display previous values till end values

[vijaykumarj19]

c1	c2	c3
may 2020	32	32
jun 2020	22	54
jul 2020		54
aug 2020		54
sept 2020	34	88
oct 2020	2	90
nov 2020
dec 2020

I have c2 column and need to display c3 running total but blank values before last value should display previous values

my table is connected to date table 

my measure:

CALCULATE(

    sum(c2),

    FILTER(

        CALCULATETABLE(

            SUMMARIZE(

                'Date Table',

                'Date Table'[cc_year-Month Sort],

                'Date Table'[Year Month]

            ),

            ALLSELECTED('Date Table')

        ),

        ISONORAFTER(

            'Date Table'[cc_year-Month Sort], MAX('Date Table'[cc_year-Month Sort]), DESC,

            'Date Table'[Year Month], MAX('Date Table'[Year Month]), DESC

        )

    )

)

but displaying cumulative till last 

[BhushanR]

If tried same scenario and try to filter the data by using slicer which I created from date field it is not giving correct count.

[wdx223_Daniel]

@vijaykumarj19 assume c1 from date table then try this code

=var _currentYM=max(datetable[year month]) return calculate(sum(c2),datetable[year month]<=_currentYM)

[vijaykumarj19]

Its not showing cumulative count

[vijaykumarj19]

My table

calculating cumulative and ploted in line graph

Below line should stop at a6 

Dax :

c2 running total in c1 =

CALCULATE(

    SUM('Table'[c2]),

    FILTER(

        ALLSELECTED('Table'[c1]),

        ISONORAFTER('Table'[c1], MAX('Table'[c1]), DESC)

))

[vijaykumarj19]

can anyone help me with the solution

[wdx223_Daniel]

@vijaykumarj19 

think you need a IF function

[vijaykumarj19]

Need to show a3 and a4 with a2 value

[wdx223_Daniel]

@vijaykumarj19 

can this work?

[vijaykumarj19]

If we have dates as axis

If i have month year from date table as axis then 

and i do have a relation between tables

Then how would this dax modified 

var c = MAX('Table'[c1])
VAR d = MAXX(FILTER(ALL('Table'),'Table'[c2]>0),'Table'[c1])
Return
IF(c<=d,
CALCULATE(SUM('Table'[c2]),FILTER(ALL('Table'),'Table'[c1]<=c)))

[wdx223_Daniel]

@vijaykumarj19 

AccTotalc2 = VAR vCurrentDate=MAX(DateTable[Date]) VAR vMaxDate=CALCULATE(MAX('Fact'[c1]),FILTER(ALL('Fact'),'Fact'[c2]>0)) RETURN IF(vCurrentDate<=vMaxDate,CALCULATE(SUM('Fact'[c2]),DateTable[Date]<=vCurrentDate))

AccTotalc4 = VAR vCurrentDate=MAX(DateTable[Date]) VAR vMaxDate=CALCULATE(MAX('Fact'[c1]),FILTER(ALL('Fact'),'Fact'[c4]>0)) RETURN IF(vCurrentDate<=vMaxDate,CALCULATE(SUM('Fact'[c4]),DateTable[Date]<=vCurrentDate))

[vijaykumarj19]

But it stoped at dec need to be extended till Jan , Because we have value for Jan also 

[wdx223_Daniel · Accepted solution]

@vijaykumarj19  try to change MAX to MIN