DAX equivalent of SQL filter not LIKE [0-9] [%a-z%]

[joshikakrishna]

Hi,

I nee apply below filter in dax query.

Please help to accomplish this requirement.

How to apply filter with not like [%A-Z%] in DAX (SSAS tabular) + powber BI

Thanks

[kazael]

@joshikakrishna

I would recommend using the search function (https://dax.guide/search/). 

You can post an example of your data and I'll try to help 

[v-shex-msft · Accepted solution]

HI @joshikakrishna,

You can use below calculate column formula to create a variable dictionary table to compare with current text column:

Contains Text = 
VAR dict =
    SELECTCOLUMNS (
        GENERATESERIES ( 97, 122, 1 ),
        "UPPER", UNICHAR ( [Value] ),
        "LOWER", LOWER ( UNICHAR ( [Value] ) )
    )
RETURN
    COUNTROWS (
        FILTER (
            dict,
            SEARCH ( [UPPER], [Text], 1, -1 ) > 0
                || SEARCH ( [LOWER], [Text], 1, -1 ) > 0
        )
    )
    > 0

In addition, you can also take a look at following blog which mentioned dax string comparison:

From SQL to DAX: String Comparison

Regards,

Xiaoxin Sheng