Question

How can I get a column value from previous row in Power Query?

Answer 1

Hi Sindhu, add this line as your measure code, then add the column into your table.

Name = Table.AddColumn(#"Added index", "custom column", each #"Added index"{[Index]-1}[My Column]).

For more information see this,

https://social.technet.microsoft.com/Forums/en-US/5577b086-1d84-4b7e-9bed-59f15b01a8b0/how-can-i-do-calculation-based-on-nextprior-row-in-power-query?forum=powerquery

Comments

You could also see this,

https://community.powerbi.com/t5/Desktop/How-to-get-previous-row-value-for-text-column/m-p/313444#M139038