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