cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
Resident Rockstar

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

Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!

7 REPLIES 7
Super User

@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

Proud to be a Super User!

Anonymous
Not applicable

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

Resident Rockstar

@Anonymous -

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

Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!

Anonymous
Not applicable

Thank you @ChrisMendoza so much!!

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

Resident Rockstar

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

Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!

Anonymous
Not applicable

Thank you so much @ChrisMendoza !! Perfect..

I just did a conditional column..

Community Support

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!

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors