Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Beginer007
New Member

Use previous row result as base of calculation

Hello folks !

I hope you are doing well 😁

 

I'm developping a tool on PBI to calculate a projected stock, i'm really blocked with the formula & DAX command.

Basicly i use the month stock of my clients to calculate their needs and i do a simulation with my shipping plan.

Here my draft :

Basicly to calculate the projected stock i do :

Projected Stock = [Stock] + [Inbound M-1] - [2024+%]

[Stock] is the declared stock by the client and its blank if we don't have the data

[Inbound M-1] is the entering stock to the client warehouse

[2024+%] is the sell-out of my client with a % of depletion

All the rows are diferents mesures coming from a data base and converted to the same unit.

Beginer007_0-1710391174271.png

What I want to do is that if my [Stock] = blank(), I use the previous result of the projected stock as [Stock] to simulate the new projected stock for the next month and do it recursively.

I hope you'll understand my problem and try to help me.

 

The column "Test2" its my tentative and its working for march but not for the other months, here my code :

 

Test 2 = if([Stock]=BLANK(),
var _step1 = [Projected Stock M-1]+[Cumul inbound M-1] - [Cumul 2024 + %]
var _step2 = if([Projected Stock M-1]=BLANK(),_step1+[Cumul Stock]+ [Cumul inbound M-1] - [CA 2024 + DEPLETION],_step1)
return _step2,[Projected Stock])

 

Many thanks to all who will take the time to help a Beginner !

 

Best regards !

1 REPLY 1
lbendlin
Super User
Super User

This is impossible to do in standard DAX as it has no concept of a modifiable aggregator.  It can be done in Power Query via List.Accumulate.  It should also be possible with the new "Visual Calculations"  that run on the visual level and can reference "PREVIOUS"  rows or columns.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to 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.

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.