Summarises each column of a table as one output row showing min, max, mean, standard deviation, row count, nulls and distinct values. It is an M function.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Table.Profile in context, with comparison tables and the common traps.
Terms in this definition
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- MIN
Gives back the lowest value found in a column holding numbers, dates or text, or compares two expressions and returns the lower. For TRUE/FALSE values, which this DAX aggregation doesn't accept, turn to MINA.
- MAX
Gives back the biggest value found in a column holding numbers, dates or text, or compares two expressions and returns the bigger. For TRUE/FALSE values, which this DAX aggregation doesn't accept, turn to MAXA.
- Standard deployment type
A Foundry deployment type billed per token that keeps processing of prompts and responses inside the Azure geography of the resource, meeting data residency needs at lower volumes.
- COUNT
A DAX function returning how many non-blank numbers, dates or text values a column contains. Boolean columns need COUNTA instead, and for counting the rows of a table COUNTROWS is the better choice.
- VALUES
Returns in DAX the distinct column values, or table rows, still visible after filters are applied, sometimes with an extra blank entry. CALCULATE often takes the result as a table filter.