Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Lookupvalue for a Search String in Tabular Model

Hi seeking assistance with Tabular Model DAX query. Sorry for posting in PBI forum. I will be mgrating this solution to existng PBI, but the roadmap for it is 6-9 month away. I've a Lookup/Reference...
  • Anonymous's avatar
    Anonymous
    5 years ago

    For those who may stumble upon similar issue -

     

    After a lot of reading everywhere, found the below link and especially in comments.

     

    A combination of a various solutions in comments helped.

    Solution Link 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks a lot Tanushree_Kapse for replying.

 

This doesnot work. Like I mentioned, I tried this, but it matches only where the match is EXACT. However I'm looking for matching a substring of the column ITEM_DESCRIPTION.

 

The ITEM_DESCRIPTION column can have other text in there. Like

Baseball needed
Baseball
Helmet wanted

 

Also this is Tabular Model. Though solution should be via DAX.

Tanushree_Kapse's avatar
Tanushree_Kapse
Impactful Individual
5 years ago

Anonymous , that's why we are CAPITALIZING every letter and splitting the column to get the substring seperated.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    But splitting cannot be 100%. i.e. I can have spaces in between for the text I need to search.

    base ball

    Shoulder pad

    • Tanushree_Kapse's avatar
      Tanushree_Kapse
      Impactful Individual
      5 years ago

      Anonymous , In that case: Use UPPER(Column_name) to convert every alphabet to uppercase.
      And for splitting the column using delimiter for rightmost space-
      RIGHT([ITEMS_DESCRIPTION],SEARCH(" ",[ITEMS_DESCRIPTION]),-1)

       

       

      I hope this helps!

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks Tanushree_Kapse  - I'll come back to this later. A priority 2 incident has happened. 😞

         

        Any other thoughts in meanwhile are welcome.