How to make condition that 'contains' a number?

[Inezyv]

Hi,

Currently I am working on a project where I have to add multiple conditional colomns where:

If the status (for example) contains '4' then yes otherwise no.

The different statusses are: 

So for example:

If I have status '129' then no, because (129 = status '128' + status '1')

But If I have status 132 then yes, because (132 = status '128' + status '4')

In MySQLworkbench I solved this by using the 'where status & 4' statement, but now I need to know how to do this in DAX.

Does anyone know a solution? 😊

[isabella]

Hi @Inezyv 

You can use expression like this:

Column = if(MOD([Column1],4)=0,"yes","no")

Best Regards,

Community Support Team _Isabella

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Hariharan_R]

Hi

you can use CONTAINSSTRING dax function.

Result = IF(CONTAINSSTRING('Table (2)'[Status],"4"),"Yes","No")

Thanks

Hari