Get previous column values to calculate new one

[Ayreon69]

Hello,

I've been struggling with a problem for a while now and I could really use some help.

I need to recreate this table.

The first column is a fairly simple formula, and the subsequent columns are calculated by taking the value from the previous column, corresponding to the previous month, except for the first month which uses the value from the first column.

So, I've created the necessary measures to calculate this table, but I can't figure out how to retrieve the previously calculated value. The formula should be something like:

For example for the 2nd of 2024 month you should do  387 +616 - 236 = 767
For the 1 month of 2023 ex : 2276 + 189 - 612 = 1853

First tab(n-1) + Ouverture N - Fermeture N.

Any assistance would be greatly appreciated! Thank you in advance.

Here is the pbix file  : help.pbix

[Ayreon69]

Can someone help me please

[Anonymous]

HI @Ayreon69,

Currently, I can't access to the share file link due to some network reasons. Can you please provide some dummy data here and pasted to your post with table format? Then we can use these dummy data to testing coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Ayreon69]

Sure, here is some example of data I have, thank's for the answer.

compteur	type	année ouverture	mois ouverture	annee survenance	stock 31/12/n-1	année fermeture	mois fermeture
1	attritionnel	2024	1	2024	0	2024	1
1	attritionnel	2023	12	2023	0	2023	12
1	attritionnel	2024	1	2024	0	2024	1
1	attritionnel	2023	12	2023	1	2024	1
1	attritionnel	2023	12	2023	1	2024	2
1	attritionnel	2023	11	2023	1	2024	2
1	attritionnel	2023	12	2023	1	2024	1
1	attritionnel	2023	12	2023	1	2024	1
1	attritionnel	2023	12	2023	0	2023	12