Forum Discussion

gaby58's avatar
gaby58
Frequent Visitor
3 years ago
Solved

How to get these values into new Column

Hi All,     In one column called Product Availability and I have values like Yes, No, May Be, Not Sure, so depending on these values I need to create a new Column and the values should be for Yes -...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi gaby58 ,

     

    Create a new custom column in Power Query like this:

    if [originalColumn] = "Yes" then "Available"
else if [originalColumn] = "No" then "Not Available"
...
...
else //your escape value e.g. null, or "Unknown" etc.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi gaby58 ,

 

Create a new custom column in Power Query like this:

if [originalColumn] = "Yes" then "Available"
else if [originalColumn] = "No" then "Not Available"
...
...
else //your escape value e.g. null, or "Unknown" etc.

 

Pete

gaby58's avatar
gaby58
Frequent Visitor
3 years ago

Thank you so much, it worked!