Simple way to check for special characters in a column using DAX
Case:Evaluate what rows of a particular column contains special characters.
In Power Pivot we are using a DAX formula to create a calculated column to check each of the rows of the name table, this will
return "special" if that name has any special character from a particular list.
this list is dynamic and you or the end user can change, add or delete the characters that needs to be evaluated.
Calculated column in example:
QualityCheck=
IF (
SUMX ( Special, FIND ( Special[List], Table2[Name],, 0 ) ) "insertgreaterthansymbol" 0,
"Special",
""
)
Find the file used here:
http://powergi.net/dax-solutions
(DAX : Scan a column to check what fields contain special characters)