Finding missing data in Power BI

Finding missing data with Python is relatively simple. However, Power BI offers an even faster way, especially if you are new to Python code.

In this exercise, you will use the Power Query Editor in Power BI to find missing values within the purchases dataset. Using column statistics, you will perform a simple imputation (i.e., replacing the missing values) with the column average.

If you have lost any progress, close any open reports and load 2_2_missing_powerbi.pbix from the Exercises folder on the Desktop.