Forum Discussion
Table calculation help!
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 |
3 Replies
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)
Anonymous , Try new column like
divide(Minx(Filter(Table, [A]>earlier([A])),[A]),[B])
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
