Forum Discussion
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...
Table.[ACCOUNTNO] not like '%[A-Z]%' is enough,
For fun only, a showcase of powerful Excel worksheet formula,
I have attached PBIX file here:
So, I am not sure why it would not calculate this part correctly:
CONTAINSSTRING( [ACCOUNTNO], "ABCDEFGHIJKLMNOPQRSTUVWXYZ" )
If this DAX formula works, it should generate total of 8074.
| $133.00 |
| $12.00 |
| $432.00 |
| $589.00 |
| $848.00 |
| $374.00 |
| $168.00 |
| $846.00 |
| $841.00 |
| $773.00 |
| $899.00 |
| $1,086.00 |
| $736.00 |
| $337.00 |
Currently, it shows 0.
I am wondering if this is something to do with data type.
Currently, in PBI file, ACCOUNTNO is in "text" data type.