function for "does not contain"

Maysantos — Mon, 08 Apr 2019 09:31:56 GMT

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.

Re: function for "does not contain"

v-evelk — Mon, 08 Apr 2019 13:29:07 GMT

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