How to fill missing value row with Other ?

[Paulyeo11]

Hi All

My report have row with missing value. i like to fill with other. can some one advise me .

[Anonymous · Accepted solution]

@Paulyeo11 -

Go to Power Query Editor

Select the column BRAND_C and look for replace values option

And  when the window opens, leave the Values to find section as blank and fill the Replace with as Others

[Paulyeo11]

Thank you very much for your sharing.