MAX

In the Ultra Transcenders books

PL-300

Each book explains MAX in context, with comparison tables and the common traps.

Terms in this definition

• 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.

• DAX

  Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.

• TURN

  If a direct link can't be made, RDP Shortpath for Windows 365 relays UDP traffic via Microsoft servers on port 3478 instead.

• MAXA

  Finds a column's highest value in DAX while scoring TRUE as 1 and FALSE as 0. Text comparisons need MAX instead.

Related terms

• Autotune

  A preview option in Fabric Spark that studies previous runs to pick better values for shuffle partitions, broadcast join threshold and max partition bytes query by query. It's disabled by default (spark.ms.autotune.enabled), limited to Runtime 1.2, and incompatible with private endpoints and high concurrency mode.

• Compute cluster

  Azure Machine Learning compute of several managed CPU or GPU nodes that scales from min_instances to max_instances with each job; set the minimum to 0 and an idle scale-down time so you pay only when jobs are running.

• Data skipping

  Avoiding reads of files that cannot hold matching rows, using column statistics such as min, max and null counts gathered per file at write time. Liquid clustering and Z-ordering improve how much gets skipped.

• effort (Claude)

  Setting on Claude that balances depth of reasoning against cost and latency. Choosing high, xhigh or max yields the most thorough reasoning; low and medium respond faster and cost less.

• FILESTREAM

  Lets SQL Server keep varbinary(max) data as ordinary NTFS files that still stay transactionally consistent with the database. TDE doesn't encrypt this data, and ledger tables can't use it.

• finish_reason

  Explains why a chat completion ended. Values are stop (completed normally), length (truncated by max_tokens or the token limit), content_filter (content omitted) and tool_calls (a tool was invoked).

• Foundry playground

  Interactive space in the Foundry portal where a deployed model can be tried out before any code is written. Users tweak temperature, top_p, max tokens and the system prompt, compare models and export sample code; production traffic does not belong here.

• Full-text index

  Built with CREATE FULLTEXT INDEX, this token-based index covers xml, character or varbinary(max) columns in a table or indexed view. Each table can have just one, and it needs a single-column, unique, non-nullable key index.