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.
Ещё видео!