Forum Discussion

Maysantos's avatar
Maysantos
New Member
7 years ago

function for "does not contain"

Hi,

If there is a function for "CONTAINS", is there also a function for "not contain". 

I would like to create a formula that will give me a table of rows that do not contain a given item, e.g. "C".

I have this formula,

if((CONTAINS(Table,column[X],"C")),(if(CONTAINS(Table,Column[Y],"C"),0,if(CONTAINS(Table,Column[Z],"C"),0,1))))
 
I would like to get the opposite of the above.

1 Reply

  • v-evelk's avatar
    v-evelk
    Microsoft Employee
    7 years ago

    Hi,

     

    If your question is about DAX it would be better to ask in Desktop thread because DAX is out of our expertise.

     

    Kind Regards,

     

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]