cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

Get previous column values to calculate new one

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

3 REPLIES 3
Regular Visitor

Community Support

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.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Regular Visitor

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

Announcements

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors