ISNOT LOOKUPVALUE

[NickKramerGU]

Hi,

Can you also use an "IS NOT" function for LOOKUPVALUE? I am trying to return a value when the status in the column is not matching the input. See the example: 

Values present in Column2

Active

Paused

Stopped

LOOKUPVALUE(TableA[Column1], TableA[Column2], ISNOT"Stopped")

But this is not working because the ISNOT is obviously not a function but also <> or ! is not helping. 

Any suggestions?

Thanks in advance. 

[v-xiaotang]

Hi @NickKramerGU 

Hope you are doing well.

Can we close this thread now if there is no other question? It would be nice if you can accpet my answer as the solution. Thanks 🙂

Best Regards,

Community Support Team _Tang

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

[v-xiaotang · Accepted solution]

Hi @NickKramerGU 

Thanks for reaching out to us.

You can try the function Related(),

e.g.

FILTER( 'InternetSales_USD', RELATED('SalesTerritory'[SalesTerritoryCountry])<>"United States")

FILTER('InternetSales_USD'
, 'InternetSales_USD'[SalesTerritoryKey]<>1 && 'InternetSales_USD'[SalesTerritoryKey]<>2 && 'InternetSales_USD'[SalesTerritoryKey]<>3 && 'InternetSales_USD'[SalesTerritoryKey]<>4 && 'InternetSales_USD'[SalesTerritoryKey]<>5)

Best Regards,

Community Support Team _Tang

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

[amitchandak]

@NickKramerGU , Try like a new column like

maxx(filter(TableA, TableA[Column2] <> "Stopped") ,TableA[Column1])

[NickKramerGU]

Hi Amit,

Don't think this is what I need. Perhaps I need to be more precise. I am using LOOKUPVALUE filtering on multiple columns like below:

NewColumn= LOOKUPVALUE(TableA[Column3], TableA[Column1], TableB[ColumnS], TableA[Column2], <> "Stopped")

But the function does not allow <>

Thanks for your help