Forum Discussion

SHDJason's avatar
SHDJason
Advocate II
10 years ago

Matching a single value to a possible value in another table?

Hi. I have been trying to figure this out and I finally give up.    Here is the situation:   I have a table of website traffic with a long list of full URLs. I have another very short table with...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
10 years ago

You can do this in dax.

 

You can use FIRSTNONBLANK combined with a filter:

 

FIRSTNONBLANK(FILTER(VALUES('Table to Search'[Field]),SEARCH('Table to Search'[Field],'Table with Main Data'[Field],1,0)),1)

  • SHDJason's avatar
    SHDJason
    Advocate II
    10 years ago

    Thanks Anonymous!  

     

    I actually woke up in the middle of the night with this solution:

     

    IF(COUNTROWS(FILTER(Mentions,IFERROR(SEARCH([Source],[Url]),BLANK())))>1,TRUE(),FALSE())

     

    Which works, but I think yours is more elegant!  

     

    For some reason I need to wrap my SEARCH and FIND functions in IFERRROR because I keep getting errors on the not found value.