Get startedGet started for free

Rounding, replacement, and sorting

Power Query has a rich set of built-in functionality to solve many common problems you might run into when loading data. In this exercise, you will perform modifications to the dataset, including rounding off columns, replacing values within columns, and changing the sort operation of columns.

If you have lost any progress, close any open reports and load 1_2_modify_table.pbix from the Exercises folder on the desktop.

This exercise is part of the course

Data Modeling in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise