Create Tables with and without Data Types in Formula using "type table" (Power Query)

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

https://learn.microsoft.com/en-us/pow...

0:00 #table()
0:33 Table.FromColumns()
1:03 Table.FromRows()
1:33 Table.FromRecords()
2:03 Table.FromList()

let
Source = null,
#"#table" = #table({"Col1", "Col2", "Date"},
{{1, 2, #date(2022, 03, 19)},
{11, 22, #date(2022, 03, 20)},
{111, 222, #date(2022, 03, 21)}
}),
#"#table_with_type" =#table(type table[Col1=Int64.Type, Col2=Int64.Type, Date=Date.Type],
{{1, 2, #date(2022, 03, 19)},
{11, 22, #date(2022, 03, 20)},
{111, 222, #date(2022, 03, 21)}
}),
Table_FromColumns = Table.FromColumns(
{{1, 11, 111},
{2, 22, 222},
{#date(2022, 03, 21), #date(2022, 03, 21),#date(2022, 03, 21)}},
{"Col1", "Col2", "Date"}),
Table_FromColumns_with_type = Table.FromColumns(
{{1, 11, 111},
{2, 22, 222},
{#date(2022, 03, 21), #date(2022, 03, 21),#date(2022, 03, 21)}},
type table[Col1=Int64.Type, Col2=Int64.Type, Date=Date.Type]),
Table_FromRows = Table.FromRows(
{{1, 2, #date(2022, 03, 20)},
{11, 22, #date(2022, 03, 21)},
{111, 222, #date(2022, 03, 21)}},
{"Col1", "Col2", "Date"}),
Table_FromRows_with_type = Table.FromRows(
{{1, 2, #date(2022, 03, 20)},
{11, 22, #date(2022, 03, 21)},
{111, 222, #date(2022, 03, 21)}},
type table[Col1=Int64.Type, Col2=Int64.Type, Date=Date.Type]),
Table_FromRecords = Table.FromRecords(
{[Col1=1, Col2=2, Date=#date(2022, 03, 19)],
[Col1=11, Col2=22, Date=#date(2022, 03, 20)],
[Col1=111, Col2=222, Date=#date(2022, 03, 21)]
}),
Table_FromRecords_with_type = Table.FromRecords(
{[Col1=1, Col2=2, Date=#date(2022, 03, 19)],
[Col1=11, Col2=22, Date=#date(2022, 03, 20)],
[Col1=111, Col2=222, Date=#date(2022, 03, 21)]
},type table[Col1=Int64.Type, Col2=Int64.Type, Date=Date.Type]),
Table_FromList = Table.FromList({
#date(2022, 03, 21),
#date(2022, 03, 21),
#date(2022, 03, 21)},
Splitter.SplitByNothing(),
{"Date"}, null),
Table_FromList_with_type = Table.FromList({
#date(2022, 03, 21),
#date(2022, 03, 21),
#date(2022, 03, 21)},
Splitter.SplitByNothing(),
type table[Date = Date.Type], null)
in
Table_FromList_with_type