Table.Column

This function retrieves a specific column of data from a designated table and displays it as a list.

Syntax

Table.Column(table as table, column as text) as list

About

This function retrieves a specific column of data from a designated table and displays it as a list.

Explanation

This code snippet retrieves the values stored in the [Name] column of the specified table. It uses the Power Query MTable.Column function to extract the values. The table consists of records with columns such as CustomerID, Name, and Phone. When executed, the output will return an array containing the names "Bob", "Jim", "Paul", and "Ringo".