Get startedGet started for free

More iterating functions

Your manager is pleased by your current employee analysis, and asks you to dive deeper by looking at the average discount rate given per order by employees. Since the Retail Price and selling price (i.e. Unit Price) are known, you can calculate the given discount by subtracting the unit price by the retail price and dividing it by the retail price. This expression is perfect to use in an iterating function, so that you don't need to create an intermediate measure first.

If you have lost any progress, close any open reports and load 4_2_iteratingfunctionscomplex.pbix from the Exercises folder on the desktop.

This exercise is part of the course

DAX Functions in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise