Dax to check alphanumric string

[Ethanhunt123]

I need to write DAX to check the alphanumeric string.  I know how to check the numeric string (ISNUM) but I think DAX are case sensitive so I am not sure how can I check alphanumeric string? 

[Anonymous]

Hi @Ethanhunt123 ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Stephen Tao

[Anonymous · Accepted solution]

Hi @Ethanhunt123 ,

You can use SWITCH() function to check.

Column =
SWITCH (
    [Column1],
    "a1", TRUE (),
    "a2", TRUE (),
    "a3", FALSE (),
    "a4", FALSE ()
)

Or, there is a workaround. You could create a keyword table (including the number of letters), and then refer to the link below to create a formula. Please refer to:

DAX – “CONTAINSX” – Finding if a value in table 1 has a matching value in table 2

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.

[CNENFRNL]

@Ethanhunt123 , on the contrary, DAX isn't case-sensitive even if you use strict equal to (==) operator; but "==" does distinguish BLANK() from 0 or "".

You might want to turn to Power Query for such case-sensitiveness tests.

[amitchandak]

@Ethanhunt123 , refer this old solution

https://community.powerbi.com/t5/Desktop/Checking-a-column-for-alpha-and-alpha-numeric-characters/td...

[Ethanhunt123]

@amitchandak  This old solution is how to check numeric string. I need to check alphanumeric string

[littlemojopuppy]

What are you trying to check?  That it is/is not numeric or that it contains something?

[Ethanhunt123]

@littlemojopuppy  I need to check alphanumeric strings

[littlemojopuppy]

Check for what?