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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
