Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I want to check if a value has three characters and the characters are alphanumeric.
How can I check that please?
It would be easy with regex.
Thanks!
Solved! Go to Solution.
If in DAX:
ISERROR(VALUE("A23")) returns true, so alphanumeric
ISERROR(VALUE("123")) returns false, so numeric
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting@UsePowerBI - Do you want a DAX or Power Query solution or do you care? And are you trying to determine if it is numeric versus alphanumeric or are you trying to figure out that it only contains certain characters (a-z, A-Z, 0-9) and not characters like period, semi-colon, etc.?
@UsePowerBI - Do you want a DAX or Power Query solution or do you care? And are you trying to determine if it is numeric versus alphanumeric or are you trying to figure out that it only contains certain characters (a-z, A-Z, 0-9) and not characters like period, semi-colon, etc.?
If in DAX:
ISERROR(VALUE("A23")) returns true, so alphanumeric
ISERROR(VALUE("123")) returns false, so numeric
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |