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

0 votes

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

Mar 18, 2019 in Power BI by Sindhu
4,829 views

1 answer to this question.

0 votes
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
answered Mar 18, 2019 by Cherukuri
• 32,490 points

Related Questions In Power BI

0 votes
1 answer
0 votes
1 answer

Can I create a Power BI report in Office 365 without my locally installed Office Excel?

Yess!! You can achieve this by using ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 51,970 points
221 views
0 votes
1 answer

How do I know who in my organization has a Power BI account?

You can view the Azure Active Directory ...READ MORE

answered Oct 15, 2018 in Power BI by Hannah
• 18,410 points
129 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,200 points
1,657 views
0 votes
1 answer

How can i see my plugin name in the Power BI Visual plugin List ?

there is a couple of errors in your ...READ MORE

answered Nov 8, 2018 in Power BI by Upasana
• 8,620 points
178 views
0 votes
1 answer

PowerQuery : How can I reference a cell's value?

You can do so using a named ...READ MORE

answered Feb 27, 2019 in Power BI by Shubham
• 13,450 points
8,748 views
0 votes
1 answer

How do you add a slicer from different table in Power BI?

In order to add a slicer from ...READ MORE

answered Mar 5, 2019 in Power BI by Phalguni
• 1,020 points
448 views
0 votes
1 answer

Why does a reference to a value in previous row throw this Expression.Error?

If you have multiple steps after the ...READ MORE

answered May 8, 2019 in Power BI by avantika
• 1,500 points
88 views
0 votes
1 answer

Calculated column with the sum of values from many columns in a row

Hi, You can create a new column by ...READ MORE

answered Mar 14, 2019 in Power BI by Cherukuri
• 32,490 points
249 views
0 votes
1 answer

How to rename a column using DAX in Power BI?

Hi Ramya, I found these two function that ...READ MORE

answered Aug 21, 2019 in Power BI by anonymous
• 32,490 points
6,292 views