Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Same If function for several columns to populate a new column

Hi,   I have this table with Client info about an assessment. In the table 56 columns has fields that has 0,1,2,3 value, where 0,1 represents Nonactionable & 2,3 represents Actionable.   I am try...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    7 years ago

    Anonymous -

    Something like 

    = Table.AddColumn(#"Changed Type", "Custom", each if [Column1] = 0 or [Column1] = 1 then "Action" else if [Column1] = 2 or [Column1] = 3 then "Non" else "N/A")
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you ChrisMendoza so much!! 

So If I have no Value & I want to replace with N/A wht should be my statement?

ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Anonymous -

Something like 

= Table.AddColumn(#"Changed Type", "Custom", each if [Column1] = 0 or [Column1] = 1 then "Action" else if [Column1] = 2 or [Column1] = 3 then "Non" else "N/A")
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you so much ChrisMendoza !! Perfect..

    I just did a conditional column..

     

    • v-diye-msft's avatar
      v-diye-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi Anonymous 

       

      Glad to know you have fixed the issue, could you plz kindly mark the helpful answer as a solution? that help others find it more quickly. thanks!