Iterating Over Calculated Tables using Power Query


Problem

Many of us are already aware of the looping methodologies in a programming language and their benefits. Looping helps us iterate over a set of items over and over again to obtain a final result. In this article, I’m going to demonstrate how to iterate/loop over a series of objects in Power BI using Power Query.

For the sake of this tutorial, I’m using the AdventureWorksDW2017 database provided by Microsoft. You can download and install the database locally. This article assumes you have some fair knowledge on how to import data into Power BI from a SQL Server table.