What is DAX?

DAX (Data Analysis Expressions) is the formula language used in Power Pivot and Power BI.

DAX is designed for:

  • Calculations
  • Measures
  • Data analysis
  • Filter context
  • Time intelligence

SUM

Adds values in a column.

Syntax

SUM(Table[Column])

Example

Total Sales :=

SUM(Sales[Sales Amount])

Product Sales

If the PivotTable is filtered by Product, the same measure automatically calculates the sales for that product.

Practice

Create:

Total Quantity :=

SUM(Sales[Quantity])

and:

Total Sales :=

SUM(Sales[Sales Amount])

PreviousNext