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 ...
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.

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.