Same If function for several columns to populate a new column

[Anonymous]

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 trying to create a new Column thet will have Actionable & Nonactionable category based on the numbers in those 56 Columns.

I am doing it by adding a conditional column (See the Image), this way I have to create 224 conditions...

My question is , is there a simple way to do this?

Thanks,

panda2018

[Nathaniel_C]

@Anonymous ,

See the pics... First you could change the Operator, which it cuts it to 2 conditions. You could add a third if you want to test other numbers. Just do one column, and see the second picture, you can see the code. Copy the code and paste it for as many columns as you have, or using the interface may be easier. Or use Chris' suggestion.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Anonymous]

Thank you!! 

Actually here the 0 has a value & If the field is completely empty I wanted to replace it with Not Applicable.

I figured it out.

Thanks!!

[ChrisMendoza]

@Anonymous -

My guess is that you should unpivot the columns and then write an IF ( OR ( 1, 2), "NonActionable", "Actionable" )

[Anonymous]

Thank you @ChrisMendoza so much!! 

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

[ChrisMendoza · Accepted solution]

@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]

Thank you so much @ChrisMendoza !! Perfect..

I just did a conditional column..

[v-diye-msft]

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!