DAX
E35616
DAX (Data Analysis Expressions) is a formula and query language used in Microsoft Power BI, Excel Power Pivot, and Analysis Services for creating custom calculations and data models.
Observed surface forms (1)
| Surface form | Occurrences |
|---|---|
| subject | 0 |
Statements (53)
| Predicate | Object |
|---|---|
| instanceOf |
expression language
ⓘ
formula language ⓘ query language ⓘ |
| acronymFor | Data Analysis Expressions ⓘ |
| basedOn | Excel formula syntax ⓘ |
| dataModelType | tabular model ⓘ |
| developer | Microsoft ⓘ |
| documentationURL | https://learn.microsoft.com/dax/ ⓘ |
| domain |
business intelligence
ⓘ
data analytics ⓘ data modeling ⓘ |
| executionEngine |
Power Pivot
ⓘ
surface form:
VertiPaq
|
| fullName | Data Analysis Expressions ⓘ |
| hasFeature |
CALCULATE context modification
ⓘ
automatic context transition in measures ⓘ row-level security expressions ⓘ |
| influencedBy | Excel functions ⓘ |
| purpose |
define calculated columns
ⓘ
define calculated tables ⓘ define custom calculations ⓘ define measures ⓘ filter and query data models ⓘ |
| supports |
aggregation functions
ⓘ
calculation groups (in tabular models) ⓘ date and time functions ⓘ filter context ⓘ filter functions ⓘ information functions ⓘ iterator functions ⓘ logical functions ⓘ parent-child hierarchy functions ⓘ query context ⓘ relationship navigation ⓘ row context ⓘ scalar functions ⓘ statistical functions ⓘ table functions ⓘ text functions ⓘ time intelligence calculations ⓘ |
| supportsEvaluation | columnar storage ⓘ |
| usedFor |
dashboard calculations
ⓘ
data model querying ⓘ enterprise BI ⓘ interactive reporting ⓘ self-service BI ⓘ |
| usedIn |
Azure Analysis Services
ⓘ
Power Pivot ⓘ
surface form:
Excel Power Pivot
Microsoft Excel Data Model ⓘ Power BI ⓘ
surface form:
Microsoft Power BI
Power BI ⓘ
surface form:
Power BI Desktop
Power BI ⓘ
surface form:
Power BI Service
Power Pivot ⓘ
surface form:
Power Pivot for Excel
SQL Server Analysis Services Tabular ⓘ |
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.