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.
Deze oefening maakt deel uit van de cursus
DAX Functions in Power BI
Praktische interactieve oefening
Zet theorie om in actie met een van onze interactieve oefeningen.
Begin met trainen