Conditional column

[Moniek]

Hi,

I have got a column with a lot of different values, text and numbers. I want only see the text values en replace the numbers values with "No" or somthing else. How can I do this? I thought to do this with a conditional column, but I don't know how to do exactly. 

Thanks!

[Mahesh0016]

please share your data demo_table snap so more understanded your problem.

[Moniek]

Thanks for offering your help. I cant upload a pbix , so I make a picture. I want to make to wish column... I have got the index and example column. I hope you understand what I mean.

[v-jingzhang · Accepted solution]

Hi @Moniek 

You can add a custom column with

if Text.Length(Text.Select([Example], {"0".."9"}))>0 then "NO" else [Example]

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!