Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
Proud to be a Datanaut!
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
Proud to be a Datanaut!
Thank you so much, it worked!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.