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 

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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Tanushree_Kapse Hi I'm back on this.

         

        Sorry I forgot to specify that it is not necessary that ITEM_DESCRIPTION will contain 1 part at the end that can be discarded. It can be like

        Baseball bat wanted by Team AZ
BaseballBat needed TeamCA
Base ball
Team NY Helmet

        It can be any weird combination.

        Hence I am specifcally looking for a lookup on part of string.

         

        Sorry for not being clear.

         

        Any help is much appreciated.