topic Re: DAX measure to check Name column for Numbers and Special Characters in DAX Commands and Tips

DAX measure to check Name column for Numbers and Special Characters

Anonymous — Tue, 03 Nov 2020 08:28:39 GMT

This has to be a DAX measure since working in a live connection model.

How to find and count any rows with a Number or special character in the Name Column. This would be a straight forward ISNONTEXT in a calculated column. Stuck on how to solve as a dax measure.

thanks.

Re: DAX measure to check Name column for Numbers and Special Characters

amitchandak — Tue, 03 Nov 2020 09:14:02 GMT

Anonymous ,Can you share sample data and sample output in table format?

Re: DAX measure to check Name column for Numbers and Special Characters

Anonymous — Tue, 03 Nov 2020 09:30:49 GMT

amitchandak Simple data quality check on Name field for no numbers and special characters. Count all TRUE in a KPI card. All of this using DAX measures only. thanks

ID	Name	Validation Check
1	"Dan"	TRUE
2	101022	TRUE
3	28392-3-3	TRUE
4	Joe Bloggs	FALSE

Re: DAX measure to check Name column for Numbers and Special Characters

amitchandak — Tue, 03 Nov 2020 10:53:34 GMT

Anonymous , refer if this video can help

https://www.youtube.com/watch?v=9sKeZbfzBTk

Re: DAX measure to check Name column for Numbers and Special Characters

Anonymous — Tue, 03 Nov 2020 11:03:21 GMT

This method will not work. I am using a live connection to SSAS and the data team are not avaiable. I have no access to amend tables or add them. I can only use DAX MEASURES.