Table.Profile

Syntax

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

About

Returns a profile for the columns in table.

The following information is returned for each column (when applicable):

  • minimum
  • maximum
  • average
  • standard deviation
  • count
  • null count
  • distinct count