Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise