Forum Discussion

vcb_001's avatar
vcb_001
Frequent Visitor
2 years ago
Solved

Filling blank values based on a string in another column

Hi everyone,   I have two columns in my data table, and I need to transform null values based on a string in the previous column. The structure of the data is quite straigthforward but, the issue i...
Need Help
Show and Tell
Tips and Tricks
  • DemoFour's avatar
    DemoFour
    2 years ago

    vcb_001 

    Try these steps

      #"Added Conditional Column" = Table.AddColumn(Source, "New Collumn", each if [SecondColumn] = "Unkown" then "Sales" else [SecondColumn]),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Conditional Column",{"FirstColumn", "New Collumn"})
in
    #"Removed Other Columns"
HarishKM's avatar
HarishKM
Icon for Super User rankSuper User
2 years ago

vcb_001 Hello,
You can go to power query and select column where you wanted replace value and
Then right click and select replace value.
this pop up box will apear then you can fill values and hit okay to replace unknown with desired result.



Thanks
Harish M