For example consider following table:
product price (calculated measure)
A 2 2
B 3 2+3=5
C 1 5+1=6
D 3 6+3=9
E 1 1+9=10
I want to create a calculated measure which does the above summations ? I want to add the value of previous row to current row and so on. Is there a prev function for example i can write as
measures.[price] + measures.prev.[price]
Please help !!
product price (calculated measure)
A 2 2
B 3 2+3=5
C 1 5+1=6
D 3 6+3=9
E 1 1+9=10
I want to create a calculated measure which does the above summations ? I want to add the value of previous row to current row and so on. Is there a prev function for example i can write as
measures.[price] + measures.prev.[price]
Please help !!