Use DAX iterator functions in Power BI Desktop models

App Maker
Data Analyst
Power BI
Microsoft Power Platform

By the end of this module, you'll learn about what the family of iterator functions can do and how to use them in your DAX calculations. Calculations will include custom summarizations, ranking, and concatenation.

Learning objectives

By the end of this module, you'll be able to:

  • Describe iterator functions.
  • Use aggregation iterator functions.
  • Calculate rankings.


You should have experience creating Power BI Desktop models and designing Power BI report layouts. You should also understand how to create Data Analysis Expressions (DAX) calculated columns, calculated tables, and measures.