Forum Discussion
Alphanumeric Values in column
How can I limit the column to only alphanumeric values?
Hi Anish76 ,
If you can use Power Query, it will be easy. The idea is to add column to mark whether it contains characters other than numbers and letters.
Here's my sample data.
if [Value] = Text.Select ( [Value],{ "a".."z", "A".."Z", "0".."9" }) then 1 else 0Then you can add this filter to write formulas in Power BI Desktop. For example,
Count rows which contains numeric, alpha, and alphanumeric values = COUNTROWS(FILTER('Table',[Contain numbers and letters]=1))Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Hi Anish76 ,
What does limit mean, is it in a bunch of numbers mixed with English strings, only English letters remain?
If possible, please provide us with some sample data and expected results. And take care to protect your privacy.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your response.
I want to search only alphanumeric values in the column, which contains numeric, alpha, and alphanumeric values.Hi Anish76 ,
If you can use Power Query, it will be easy. The idea is to add column to mark whether it contains characters other than numbers and letters.
Here's my sample data.
if [Value] = Text.Select ( [Value],{ "a".."z", "A".."Z", "0".."9" }) then 1 else 0Then you can add this filter to write formulas in Power BI Desktop. For example,
Count rows which contains numeric, alpha, and alphanumeric values = COUNTROWS(FILTER('Table',[Contain numbers and letters]=1))Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
