Data Analysis & DAX Functions

The Data Analysis Expressions (DAX) language is a formula language that allows users to define custom calculations in calculated columns and measures. DAX includes some of the functions that are used in Excel formulas, and additional functions that are designed to work with relational data and perform dynamic aggregation.
  • Introduction to power pivots
  • Data Model
  • Calculating Measures
  • Calculated columns
  • Relationships- Alternate to Vlookup
  • How A relational model reduces size of the file.
  • DAX

Functions Covered

Aggregation
SUM, AVERAGE
MIN, MAX
SUMX (and other X functions)

Counting
COUNT, COUNTA
COUNTBLANK, COUNTROWS
DISTINCTCOUNT

Logical
AND, OR
NOT
IF, IFERROR

Additional Functions
CALCULATE
DIVIDE
COLUMN
RELATED
TODAY
DATEDIF
SWITCH
HASONEVALUE
VALUES
COUNTROWS
FORMAT
SUMX