Power Query: How to get Values from Tables, Lists, and Records

Описание: #powerquery #power_query

Get Record from Table Row using curly braces { }
Get List from Table Column using square brackets [ ]
Get Table from Table using square brackets [ [ ] ]
Table.ToColumns
Table.ToRows
Record.ToList
Record.ToTable
Table.FromRecords
Table.FromList
Table.FromColumns
Get value from Table using both { } and [ ]
Key Match Lookup

Advanced Editor Code:
let
Source = null,
T1 = #table({"Col1", "Col2", "Col3"},{{"1", "2", "3"}, {"11", "22", "33"}, {"111", "222", "333"}, {"A", "B", "C"}, {"AA", "BB", "CC"}, {"AAA", "BBB", "CCC"}}),
Record_from_Table = T1{2},
List_from_Table = T1[Col3],
Table_from_Table = T1[[Col1], [Col3]],
Table_to_Columns = Table.ToColumns(T1),
Table_to_Rows = Table.ToRows(T1),
R1 = T1{2},
Recort_to_Value = R1[Col2],
Record_to_List = Record.ToList(R1),
Record_to_Table_Columns = Record.ToTable(R1),
Record_to_Table_Rows = Table.FromRecords({R1,R1}),
L1 = T1[Col3],
List_to_Value = L1{3},
List_to_Table_Col1 = Table.FromList(L1,null,{"Column Name"}),
List_to_Table_Col2 = Table.FromColumns({L1},{"Column_Name"}),
Table_to_Value = T1[Col2]{1},
Key_Match_Lookup = T1{[Col1="111"]}[Col2]
in
Key_Match_Lookup


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please checkout my book, Power Query M Language Basics Kindle Edition
https://www.amazon.com/dp/B0DM73H3RV
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~