Forum Discussion

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

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")

Nathaniel_C

Community Champion

7 years ago

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

Not applicable

7 years ago

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