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 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!