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"
DemoFour's avatar
DemoFour
Icon for Continued Contributor rankContinued Contributor
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"