Showing results for 
Search instead for 
Did you mean: 


Hello, could someone help me

I have two calculations made by measure "Total parts" = "good parts" + "quantity" and the 2 second calculation is "FPY Station" = "good parts" / "Total parts".


Now I need another calculation that does the following:

I have FPY Station I need "FPY Accumulated"

99.87% = 99.87%

99.88% (99.88%) x (99.87%) / (100) = 99.75%

99.61% (99.61%) x (99.75%) / (100) = 99.36%

99.54% (99.54%) x (99.36%) / (100) = 98.90% ....

in other words

A1 = B1

A2 A2xB1 = B2

A3 A3xB2 = B3

A4 A4xB3 = B4 ....

Please and thank you!

Community Support
Community Support

Here is the similar post, check the 2nd reply and you need change the calculation in the new column step. But your calculation uses measure, it can be complex since you may need to create those measures using custom column in power query.

Multiply a result for a value in other column - Microsoft Power BI Community



Paul Zheng _ Community Support Team

Super User
Super User

@Syndicate_Admin This is an extremely similar question to one that was just recently asked. The same answer applies, you are trying to essentially do a "Previous Value" problem aka recursion. DAX is not good at this sort of thing. Previous Value (“Recursion”) in DAX – Greg Deckler

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@Syndicate_Admin So how can I achieve this in power query? Is there any way to achieve the result?

Thank you

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.