Pro DAX with Power BI: Business Intelligence with PowerPivot and SQL Server Analysis Services Tabular

© Philip Seamark, Thomas Martens 2019

P. Seamark, T. MartensPro DAX with Power BIhttps://doi.org/10.1007/978-1-4842-4897-3_6

6. Iterators

Philip Seamark¹  and Thomas Martens²

(1)

UPPER HUTT, New Zealand

(2)

Hamburg, Hamburg, Germany

 

Introduction

A workhorse set of functions in the DAX language are the iterator functions. These can sometimes be known as X functions because most of these functions have an X as the last character in the function name. These functions are referred to as iterators because their fundamental purpose is to execute a DAX expression inside a series of loops. Iterator functions iterate over a table stopping at each row to process a DAX calculation, hence the name iterators.

Note

Iterators provide functionality similar to FOREACH- ...