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)
Watch video Simple way to check for special characters in a column using DAX online without registration, duration hours minute second in high quality. This video was added by user Power GI 07 March 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 18,207 once and liked it 36 people.