Cumulative total of calculaton

[hejszyszky]

Desired output :

I've provided you file on private message, will post result once solved 

[amitchandak]

@hejszyszky ,

VAR RowDate = max(Periods[Period])
RETURN
CALCULATE (
calculate(IAR_Final_Database[Risk M vs M-1]),
FILTER (
IAR_Final_Database,
IAR_Final_Database[Period] <= RowDate  && IAR_Final_Database[Period] >0  ))

or

VAR RowDate = max(Periods[Period])
RETURN
CALCULATE (
calculate(IAR_Final_Database[Risk M vs M-1]),
FILTER (
allselected(IAR_Final_Database),
IAR_Final_Database[Period] <= RowDate  && IAR_Final_Database[Period] >0  )) +0

[hejszyszky]

 Ive tried that and its still outputting same values. I guess there is a problem with columns 1-3.

Maybe you could find somwhere a mistake:

COl 1 formula : 

Risk M = calculate(SUM('IAR_Final_Database'[Finance Risk]))

Col 2 :

Risk M-1 = CALCULATE(sum('IAR_Final_Database'[Finance Risk]),PREVIOUSMONTH(DATESMTD(Periods[Date])),all(Periods[Period]))

Col 3:

Risk M vs M-1 =

calculate(IAR_Final_Database[Risk M],filter(Periods,Periods[Period]<>0)) - calculate(IAR_Final_Database[Risk M-1])

Where table periods looks like :

Do you see where is the catch/problem ?

[amitchandak]

@hejszyszky , Try like

VAR RowDate = max(Periods[Period])
RETURN
CALCULATE (
calculate(IAR_Final_Database[Risk M vs M-1]),
FILTER (
IAR_Final_Database,
IAR_Final_Database[Period] <= RowDate -1 ))

I think You need till last month.

or

Can you share sample data and sample output in table format?

[hejszyszky]

Still getting output as below:

Where my desired output is : 

[amitchandak]

@hejszyszky , Shared file on mail

[amitchandak · Accepted solution]

@hejszyszky 

Try like

Risk M vs M-1 Cumm = if( not(isblank(IAR_Final_Database[Risk M])) && HASONEVALUE(Periods[Period]), CALCULATE(sumx(values(Periods[Period]),[Risk M vs M-1]), filter(ALLSELECTED(Periods), Periods[Period] <= max(Periods[Period]) )) -CALCULATE([Risk M vs M-1],Periods[Period]=0) , BLANK())