Table.Profile

The function retrieves a profile containing various statistical information for the columns in a given table. This information includes the minimum value, maximum value, average, standard deviation, c...

Syntax

Table.Profile(table as table, optional additionalAggregates as nullable list) as table

About

The function retrieves a profile containing various statistical information for the columns in a given table. This information includes the minimum value, maximum value, average, standard deviation, count of values, count of null values, and count of distinct values for each column.