Forum Discussion
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. ...
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.
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.
Ok. I will have a crack in the morning:)
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.