Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to fill missing value row with Other ?

Hi All

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

 

  • Anonymous's avatar
    Anonymous
    5 years ago

    Anonymous -

    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

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous -

    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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you very much for your sharing.