cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Formula

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".

Bremaciel_1-1628465167016.png

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!

3 REPLIES 3
V-pazhen-msft
Community Support
Community Support

@Syndicate_Admin 
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

Greg_Deckler
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

Announcements
Carousel_PBI_Wave1

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.