Forum Discussion
lionelv
3 years agoFrequent Visitor
Increase from the previous month
Hi, I try to increase the column Amount from the previous month with an Increase factor. In Excel, it’s super easy to do. In D8 you write: “=D7*C8” and you drag down the formula. But how to do that ...
lionelv
3 years agoFrequent Visitor
Hi adudani,
Thanks, but it add only one new value and in an other column. Consequantly, it stop there and does'nt continu untile the end of the list. As far as I read sefl referencing column are not allowed in PowerQuery. I still try to find a solution.
adudani
3 years agoMemorable Member
lionelv , thanks for letting me know.
Maybe this is helpful: Get Value from Previous Row using Power Query - BI Gorilla