Table.FromPartitions

This function produces a table by merging multiple partitioned tables. The partition column to be added is specified by partitionColumn. By default, the column type is set to any, but it can be custom...

Syntax

Table.FromPartitions(partitionColumn as text, partitions as list, optional partitionColumnType as nullable type) as table

About

This function produces a table by merging multiple partitioned tables. The partition column to be added is specified by partitionColumn. By default, the column type is set to any, but it can be customized using partitionColumnType.

Explanation

Identify the specific item type based on the list of numbers provided. The Power Query MTable function is utilized to partition the data into different sections, including by year, month, and day. Each partition contains a table with specific values assigned to the parameters. The final output is a table with records indicating the values for each parameter, such as Foo, Day, Month, and Year.