Get startedGet started for free

Data cleaning with DAX

Sometimes you have to clean up existing columns before you can create new calculated columns.

We want to add the retail price to our fact table for an item, but the retail price in the dimensional table is not formatted correctly. You will be cleaning up this column so we can add it afterwards.

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

This exercise is part of the course

DAX Functions in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise