Table.FromPartitions is a Power Query M function that returns a table resulting from combining a set of partitioned tables. The function returns a combined table with an added partitionColumn.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Table.FromPartitions(
partitionColumn as text,
partitions as list,
optional partitionColumnType as nullable type,
) as tableDescription
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.
Examples
Find item type from the list {number}.
Table.FromPartitions(
"Year",
{
{
1994,
Table.FromPartitions(
"Month",
{
{
"Jan",
Table.FromPartitions(
"Day",
{
{1, #table( {"Foo"}, {{"Bar"}} )},
{2, #table( {"Foo"}, {{"Bar"}} )}
}
)
},
{
"Feb",
Table.FromPartitions(
"Day",
{
{3, #table( {"Foo"}, {{"Bar"}} )},
{4, #table( {"Foo"}, {{"Bar"}} )}
}
)
}
}
)
}
}
)
/* Output:
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
]
} )
*/
Related functions
Other functions related to Table.FromPartitions are:
