Forum Discussion
connect two tables with some common string
Hi all,
I have two tables in power bi:
1: With Projects Names
2: With URL (which includes project names)
For the 2 table there are many different URL's with same project name.
I want to somehow connect these two table so that I can use table 1 as a visual filter(drop down).
For ex.
Hi Anonymous,
To achieve your requirement, you can use SEARCH() function to match two tables. Please refer to following calculated column with DAX expression:
Key Column = CALCULATE ( IF ( COUNTROWS ( VALUES ( 'Project Names'[Project Names] ) ) > 1, "More than 1 Project Names", VALUES ( 'Project Names'[Project Names] ) ), FILTER ( ALL ( 'Project Names'[Project Names] ), SEARCH ( 'Project Names'[Project Names], 'URL'[URL], 1, 0 ) <> 0 ) )Thanks,
Xi Jin.
