Forum Discussion

JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

How to express this SQL expression: Table.[ACCOUNTNO] not like '%[ABCDEFGHIJKLMNOPQRSTUVWXYZ]%'

I am trying to express bottom SQL statement in DAX: Table.[ACCOUNTNO] not like '%[ABCDEFGHIJKLMNOPQRSTUVWXYZ]%'   I tried with  not ( CONTAINSSTRING( 'Table'[ACCOUNTNO], "ABCDEFGHIJKLMNOPQRSTUVW...
Need Help DAX
  • CNENFRNL's avatar
    CNENFRNL
    4 years ago

    Table.[ACCOUNTNO] not like '%[A-Z]%' is enough,

     

     

     

    For fun only, a showcase of powerful Excel worksheet formula,

  • JustinDoh1's avatar
    JustinDoh1
    4 years ago

    CNENFRNL, amitchandak 

    I ended up finding solution by creating a separate Char table.

     

     

     

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
4 years ago

Table.[ACCOUNTNO] not like '%[A-Z]%' is enough,

 

 

 

For fun only, a showcase of powerful Excel worksheet formula,