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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
