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

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

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


Follow on LinkedIn
@ 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!:
The Definitive Guide to Power Query (M)

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.