A SQL clause that turns each distinct value of a column into its own column, aggregating the data along the way. UNPIVOT reverses it.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains PIVOT in context, with comparison tables and the common traps.
Terms in this definition
- Serverless
Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.
- UNPIVOT
Turns several columns into rows, with one column carrying the former column names and value columns carrying their data; it is the opposite of
PIVOTand needs Databricks Runtime 12.2 LTS or later.
Related terms
- 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.