Absolute value and rounding
You are tasked with analyzing arguably the most important part of the Adventure Works Cycles dataset: sales data. Your manager has been impressed with your work so far so he is sure you will be able to clean this data up as well.
He tells you that there are a few columns that need adjustment before going into the report as there seems to be negative values in them. He also let you know that the company convention is to round all sales-related figures to one decimal place, so he wants you to make sure that you do that.
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
