Forum Discussion
Alphanumeric Values in column
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.
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 0
Then 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.
Hi Stephan,
The query only checks special characters and returns the value false. I have cells in my table that are only numeric, alphabetic, and alphanumeric with no special characters, and I want to have only alphanumeric values.