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 - Available, No - Not Available,  May Be - May Be Available, Not Sure - Need to Be Researched, Any help is appreciated.

 

Thank You

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

2 Replies

  • 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