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