Forum Discussion

vincentakatoh's avatar
vincentakatoh
Icon for Helper IV rankHelper IV
9 years ago

Production Cumulative calculation (1 table)

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.    ...
Need Help
vincentakatoh's avatar
vincentakatoh
Icon for Helper IV rankHelper IV
9 years ago
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's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
Ok. I will have a crack in the morning:)
  • vincentakatoh's avatar
    vincentakatoh
    Icon for Helper IV rankHelper IV
    9 years ago

    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