Value in cell calculated on previous cell value

[AlexandrLosenok]

Mês	Ent	0M	1M	2M	3M	4M	5M	6M	7M	8M	9M	10M	11M	12M	13M	14M	15M	16M	17M	18M	19M	20M	21M	22M	23M	24M+
01/01/2023	83	79	47	67	37	45	27	27	26	21	26	21	23	24	19	23	22	20	17	19	19	17	16	16	16	19
01/02/2023	72	68	71	44	45	31	40	24	27	26	20	25	21	23	24	19	23	21	20	17	19	19	17	16	16	19
01/03/2023	58	57	61	59	26	40	26	36	23	24	26	20	23	21	22	22	19	22	21	19	17	17	19	17	16	19
01/04/2023	52	48	49	57	40	24	39	25	36	22	23	26	19	22	21	21	22	19	22	21	19	17	16	19	17	19
01/05/2023	85	67	67	47	29	39	22	23	25	25	21	20	23	18	19	21	21	20	19	20	20	19	17	16	16	19
01/06/2023	77
01/07/2023	79
01/08/2023	62
01/09/2023	50
01/10/2023	50
01/11/2023	74
01/12/2023	35

Hi everyone!

I have the next table (example is above. First row has Headers)

The table represents number of a product units by number of months it stays in stock. So ENT shows us how much product comes into the stock. 0M - how much units remains before the end of the first month, 1M - how much units remains in stock more than 1 month but less then 2; 2M - more then 2 months but less then 3 etc.
Values in the ENT column are defined. COEF - shows the proportion of the group that will remains in stock one more month.

The values up to previous month (Columns '0M', '1M' etc) are filled manually in the source.  Values for other months must be calculated like this:  Value of the previous month * coef.  So the June value is calculated on the base of the May value, the July value is calculated on the base of calculated June value, etc.
Coef = SUM(Column n+1[2st row : actual month row] SUM(Column n [1st row : actual month - 1 row])

Here is an exemple of desired result in excel (only the values must be calculated for each month until the end of the year)
Also Sum function will be flexivel such the the bottom cell of the interval will be linked to actual month (i.e. instead of =SUM(C2:C5) there will be something like = CALCULATE(SUM(C), FILTER(Datetable, Datetable[year] = year_now &&  Datetable[month] = month_now - 1))

How do I create a measure or a column that helps me with this?
 

[Fechner]

I unsterstand how one could calculate the values for the following month but could you go into more detail on how to calculate the values for the rest of the year when the Values from C7 to C13 are missing in your exspected output?

[AlexandrLosenok]

In this case we are using the same COEF for the rest of the year. Such as for August we will multiply forecasted value for July and COEF that calculated in actual month. In other words we consider that the COEF will remain the same for the rest of the year.

[Fechner]

So you are basically leaving the rest of the 0M Column blank and calculate everything using C16 and C6. Is that right?

[AlexandrLosenok]

Not exactly. The column C for blank cells is calculated using the values from the column B and Fixed coefficient. I have made alterations in the post to clarify this and some more explanations.
Then we use real value from previous month in C (C6) to calculate forecatsed value in D in the next month (D7), also we using forecated value for the next month in C(C7) to calculate forecasted value in D in two months (D8) etc. 

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[AlexandrLosenok]

@lbendlin thank you for recomendations. I have corrected the post.