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
- lbendlin
Super User
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)
- amitchandak
Anonymous , Try new column like
divide(Minx(Filter(Table, [A]>earlier([A])),[A]),[B])
v-deddai1-msftCommunity Support
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
