Carry forward of data value from one measure to another

[hozefamk]

I have a table where i Have Total amount for current month  and Total arrivals  and Total Sales Target for Next 4 months. I calculate Closing stock using formula as Total amount + Total arrivals - Total Sales Target from where i get Closing Stock for Current Month. Now my query is I have Closing stock for current month which should be the Total amount for Next month. For example from the image Closing stock for sept is 226.74 that should be the Total Amount for Oct month and same should go on till December. 

I have two files attach below one is the value which i am getting and second is the solution which is needed.

Measures are created for all columns shown below.

Any help would be appreciated.

[v-frfei-msft · Accepted solution]

Hi @hozefamk,

Please check the sample as below. Here I create the measures as below.

Total Amoun = CALCULATE(SUM(Table1[Total Amount]))

Total arrival = CALCULATE(SUM(Table1[Total arrivals]))

Total Sales Targe = CALCULATE(SUM(Table1[Total Sales Target]))

Measure = [Total Amoun]+[Total arrival]-[Total Sales Targe]

Measure 2 = 
var curre = MAX(Table1[Index])
return 
CALCULATE([Measure],FILTER(ALL(Table1),Table1[Index]<=curre))

For more details, please check the pbix as attached.

Regards,
Frank

[v-frfei-msft]

Hi @hozefamk,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank