Forum Discussion

smoka3's avatar
smoka3
Frequent Visitor
6 years ago
Solved

Lookupvalue using Search\ContainsString?

Hi Experts, could you please help in finding the solution for my requirement   I have 2 tables with 40K rows in each table, I have slicer with package column from Table A and i have a table visual...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    smoka3 , Create a new column in TableB

     

    maxx(filter(TableA, CONTAINSSTRING(TableB[Command], TableA[Package])),TableA[Package])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

smoka3 , Create a new column in TableB

 

maxx(filter(TableA, CONTAINSSTRING(TableB[Command], TableA[Package])),TableA[Package])

  • smoka3's avatar
    smoka3
    Frequent Visitor
    6 years ago

    Thanks You! 

  • hdemedici100's avatar
    hdemedici100
    Frequent Visitor
    1 year ago

    I've just used this for a similar solution, and it's worked perfect! Thank you!