Powerpivot table simple formula

[diimoo1]

Hi all,
I am trying to add a simple new measures in power pivot table - not sure if this possible ...
but here is what i have ( table)
2 ----- na
10 ----- 4
20 ----- 10
6 ----- 3
want create a new measure from above table ( say column "c")

2 ---- na ---- 6
10 ----- 4 -----7
20 ----10 ---- 3

In a normal excel formula here how we can get in column "C"..
( a3+b3)/a2 = c2 ,
a4+b4/a3 = c3 and so an.


Please let me know the possibilities.

 

[diimoo1]

Re: Powerpivot table simple formula ( correction)

Hi all,
I am trying to add a simple new measures in power pivot table - not sure if this possible ...
but here is what i have ( table)
2 ----- na
10 ----- 4
20 ----- 10
16 ----- 4
want create a new measure from above table ( say column "c")

2 ---- na ---- 7
10 ----- 4 -----3
20 ----10 ---- 1

In a normal excel formula here how we can get in column "C"..
( a2+b2)/a1 = c1 ,
a3+b3/a2 = c2 and so an.


Please let me know the possibilities.

 

[scottsen]

Re: Powerpivot table simple formula ( correction)

In general, no. There are now A1 style referencing in PowerPivot, no way to say "the row right above this one".

That said, it is very likely that a solution is possible, if you posted a bit more "real" data. We can probably "lookup" based on an ID column, etc... to do something similar.