Download Excel Start Files: http:\/\/bit.ly\/2UOzeiw
\nEntire page with all Excel Files for All Videos: http:\/\/bit.ly\/1kSFWvs<\/p>\n
In this video learn how to perform a two-way lookup to get the value from the previous row in order to calculate the change in stock price from day to day.<\/p>\n
1. (00:10) Introduction
\n2. (00:48) Formula in Excel
\n3. (01:33) Two Way Lookup to Get Previous Row M Code Formula Syntax
\n4. (05:16) Add Index Column that starts at -1
\n5. (06:08) Two Way Lookup Power Query Formula, including looking at Table, Record and literal values in a column.
\n6. (10:08) Formula to calculate Stock Price Change
\n7. (10:36) Power Query if function
\n8. (12:13) Summary
\nOther notes:
\nPower Query is base 0
\nTwo-Way Lookup: TableName{RowIndexNumber}[Column Name]\nTwo-Way Lookup: TableName{[Lookup Operator]}[Column Name]\nFormula we use: AddedIndex{[Index]}[GEClose]\nAddedIndex = Full Table with Columns and Rows
\n{ } = Positional Index Operator
\n[Index] = Lookup Operator
\n[GEClose] = Field Access Operator<\/p>\n