Cumulative total with exlucsion

[hejszyszky]

Hi, im having calculation which looks like above.

I'd like to exclude Period 0 calculation in column 4. So my desired output looks like below (ive tried with &&Period<>0 but it does not work):

 

Could someone help? Thanks in advance!

[amitchandak]

@hejszyszky , Check if these two measures can help

Risk M Cumm = if( not(isblank(IAR_Final_Database[Risk M-1])), CALCULATE(SUM('IAR_Final_Database'[Finance Risk]), filter(ALLSELECTED(Periods), Periods[Period] <= max(Periods[Period]) -1)), BLANK())

Risk M Cumm 1 = if( not(isblank(IAR_Final_Database[Risk M])), CALCULATE(SUM('IAR_Final_Database'[Finance Risk]), filter(ALLSELECTED(Periods), Periods[Period] <= max(Periods[Period]) )), BLANK())

[hejszyszky]

Hi @amitchandak , its definetly closer. But still does not match desirred output.

Where desired output is :

 

[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())