Power Query
Search…
Table.FromPartitions
Table.FromPartitions
Returns a table that is the result of combining a set of partitioned tables.
function (partitionColumnas text,partitionsas list, optionalpartitionColumnTypeas nullable any) as table
Description
Returns a table that is the result of combining a set of partitioned tables,
partitions. partitionColumn is the name of the column to add. The type of the column defaults to any, but can be specified by partitionColumnType.Category
Table.Row operations
Examples
Find item type from the list
{number}.1
Table.FromPartitions(
2
"Year",
3
{
4
{
5
1994,
6
Table.FromPartitions(
7
"Month",
8
{
9
{
10
"Jan",
11
Table.FromPartitions(
12
"Day",
13
{
14
{
15
1,
16
#table({"Foo"},{ {"Bar"} })
17
},
18
{
19
2,
20
#table({"Foo"},{ {"Bar"} })
21
}
22
}
23
)
24
},
25
{
26
"Feb",
27
Table.FromPartitions(
28
"Day",
29
{
30
{
31
3,
32
#table({"Foo"},{ {"Bar"} })
33
},
34
{
35
4,
36
#table({"Foo"},{ {"Bar"} })
37
}
38
}
39
)
40
}
41
}
42
)
43
}
44
})
Copied!
Table.FromRecords({ [ Foo = "Bar", Day = 1, Month = "Jan", Year = 1994 ], [ Foo = "Bar", Day = 2, Month = "Jan", Year = 1994 ], [ Foo = "Bar", Day = 3, Month = "Feb", Year = 1994 ], [ Foo = "Bar", Day = 4, Month = "Feb", Year = 1994 ] }, { "Foo", "Day", "Month", "Year" })
Last modified 3yr ago
Copy link