Forum Discussion

NickKramerGU's avatar
NickKramerGU
Regular Visitor
4 years ago
Solved

ISNOT LOOKUPVALUE

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. 

Need Help
Tips and Tricks
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    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.

4 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    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.

    • NickKramerGU's avatar
      NickKramerGU
      Regular Visitor
      4 years ago

      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
  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    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.