Get startedGet started for free

Column quality and missing values

Here we'll use the Column quality feature to check if our columns have any missing values.

Our manager has informed us that some products have missing data. We can't maintain a proper database with missing values! Use the features of Power Query to diagnose which columns have missing values and then fix them.

If you lost any progress, load the workbook 2_2_column_quality.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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise