Programming & Scientific Computing · Statistical & BI Software

Power BI: DAX language — technical and scientific reference

Public introduction · full guide in Eikos

Introduction

What this guide covers

Comprehensive technical treatise on Data Analysis Expressions. Formal analysis of the VertiPaq engine, algebraic semantics of the evaluation context, optimization of the execution plan and implementation of research level analytical patterns.

Overview

Topics covered

  • Introduction
  • Semantic Modeling and DAX Language
  • VertiPaq Engine Architecture
  • Columnar Compression and RLE Algorithms
  • Execution Architecture: Formula Engine vs. Storage Engine
  • Formula Engine (FE)

Related concepts

Main connections

  • SQL & relational data modeling
  • Outliers & influence diagnostics
  • Linear algebra & matrices
  • Mean & expected value
  • Supervised machine learning
  • Data granularity & row semantics

Compatible notation

Mathematical sample in LaTeX

The expression is rendered accessibly, with its LaTeX source preserved below.

Sraw=M⋅⌈log2(N)⌉ bits
View LaTeX sourceS_{\text{raw}} = M \cdot \lceil \log_2(N) \rceil \text{ bits}