Table.FromValue
Generates a table that includes a column with the specified value or list of values. Users have the option to include a parameter, called options, which can be used to adjust the following settings: ...
Generates a table that includes a column with the specified value or list of values. Users have the option to include a parameter, called options, which can be used to adjust the following settings:
DefaultColumnName: The name of the column to be used if a table is created from a single value or list of values.
Example 1
Generate a table with the value 1.
Technical Usage:
Power Query M
Table.FromValue(1)
Output:
Table.FromRecords({[Value = 1]})
Example 2
Generate a table from the provided list.
Technical Usage:
Power Query M
Table.FromValue({1, "Bob", "123-4567"})
Output:
Table.FromRecords({
[Value = 1],
[Value = "Bob"],
[Value = "123-4567"]
})
Example 3
Generate a table with the value 1, using a custom column name.
Technical Usage:
Power Query M
Table.FromValue(1, [DefaultColumnName = "MyValue"])
Output:
Table.FromRecords({[MyValue = 1]})