Missing Value Imputation in Power Query – Replace Blanks with the Column Average

Missing Value Imputation is a very important step while preparing data for further Analysis and Cleaning. One way could be to replace missing values with the Average of other values of respective columns.

For e.g., column values are 2;null;4;null (where null denotes blank/missing value). So our task will be to replace all the nulls in this column with the Average (2 + 4)/2 = 3. So Column Values will now be 2;3;4;3

In this Video, we will see that how we can do this with the help of Power Query M Functions.

[samreenabjani]

This is only applicable when the data is only numerical and has no text.

[janwillemvanholst]

I love the conciseness of your videos! Thx.