Practice with iterating functions
Iterating functions are great for performing computations row by row and should be used when you don't want to aggregate all the values at once for computation. In this exercise, you are trying to find out the profit ratio for a given employee. The profit ratio is a performance indicator in business analytics that tells how well someone or something is performing. For the profit ratio we need to perform a row-wise analysis to divide the total profits by the total revenue.
If you have lost any progress, close any open reports and load 4_1_iteratingfunctions.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
