Table calculation help!

[Anonymous]

Looking for some help to replicate the below calculation in Column C a table/matrix.  Column A and Column B are both measures.

	A	B	C
1	2	2	=A2/B1
2	22	19	=A3/B2
3	184	135	=A4/B3
4	1069	576	=A5/B4
5	3826	1187	0

[v-deddai1-msft]

Hi @Anonymous ,

How did you get A1,A2,A3 in your sample if A is measure and you didn't contain any row level filter for measure A?

Best Regards,

Dedmon Dai

[amitchandak]

@Anonymous , Try new column like

divide(Minx(Filter(Table, [A]>earlier([A])),[A]),[B])

[lbendlin]

is this table ordered, and if yes, by what? Do you have an index column (row number)? If not, what are the criteria to identify "A3"  (for example)