function for "does not contain"

[Maysantos]

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.

[v-evelk]

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
pbicvsupport@microsoft.com