Get startedGet started for free

Multiplication, addition, and square root

After removing negative values, the next step is to fix the Discount and Unit Price Discount Pct columns. The company usually states their discount as a negative value so that the impact is clear and it is easy to distinguish from the other columns. In addition, something seems to have gone wrong with the discount percentage column itself as the values are too small.

If you lost any progress, load the workbook 4_2_arithmetic.pbix from the Exercises folder on the Desktop and open the Power Query editor.

This exercise is part of the course

Data Preparation in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise