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.
Questo esercizio fa parte del corso
DAX Functions in Power BI
Esercizio pratico interattivo
Passa dalla teoria alla pratica con uno dei nostri esercizi interattivi
Inizia esercizio