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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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