Production Cumulative calculation (1 table)

[vincentakatoh]

Hi, 

Love the drill down function of PowerBI. Is it possible to have below table in excel in 1 PBI table?

Below is what I get using PBI vs one I need in excel. 

Sample file attached. 

[Phil_Seamark]

Hi @vincentakatoh

Just trying to understand your question.  Is it that you are pretty close with your Power BI table except for the cells in the Excel image where the numbers are red?

eg, for the top row SMT for the 4/25/2017 excel is showing 9% whereas PBI is showing 1.2%

To me all the other numbers look good.  

[vincentakatoh]

Hi @phil

Yes. Trying to get the number in red. Currently the table multiply everything in series.

In addtion, possible to get the numbers using the table "data" instead of using a new table "yield"?

Thks for picking this up. All thanks to you, i was able to get the number for "line".

Rgds,
Vincent.

[Phil_Seamark]

Ok. I will have a crack in the morning:)

[vincentakatoh]

Hi @Phil_Seamark,

Any luck? 

I was able to get the values at the top by creating a 2nd table (Excluding "Line"). Nonetheless, was hoping to achieve the same calculation with just 1 addtional table or no additional table (using original "data" table). Still unable to get the values on the right. 

Sample data