Running Multiplication-Power Query

[anks_275]

I keep thinking this should be easy but the answer is evading me. I would like to transform the value in each row of a column based on another column's value.
First cell in eff column is result of multiplication of Qty and rate and second cell is result of First value in Eff cell and 2nd value in rate column and so on. But the problem is as my product changes I need to perform same calculation for that product as well. For example in below table my product changes to B in table, i need to perform same calculation for that as well. Kindly help

Index	Product	QTY	Rate	Eff
1	AC	1	0.9811	0.9811
2	ACC	1	1	0.9811
3	ACCC	5026	0.9278	0.9102
4	AD	2034	1	2034
5	ADA	1	1	2034
6	ADAA	1	0.9	1830.6

<tbody>
</tbody>

 

[Matt Allington]

I think you are looking at this like it is a spreadsheet, but it is a database. A data base has no concept of "current row", previous row. This is maybe something you could do in power query. But a better approach is for you to explain the end state of what you are trying to do. Maybe there is a better/different way that you haven't thought of yet.