Forum Discussion
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...
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")
ChrisMendoza
Resident Rockstar
Resident RockstarAnonymous -
My guess is that you should unpivot the columns and then write an IF ( OR ( 1, 2), "NonActionable", "Actionable" )