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.

amitchandak's avatar
amitchandak
Super User
4 years ago

NickKramerGU , Try like a new column like

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

  • 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