Forum Discussion
Solved
Search in a text column for values in another table Column using DAX and map the values
Hello, I've two tables Masterdata and Regions. Masterdata has a column called 'consolidated Region' and Region table has only one column 'Regions'. This table contains unique values of region. samp...
bharath_v
Resolver I
Resolver IHi DikshaT
The desired output seems a bit ambiguous.
Eg: For EUS, there are 4 different values how is it derived? Also you mentioned "Region" table is unique then why do you have 4 rows of EUS?
| Regions | Calculated column |
| EUS | AMN EUS EUN |
| EUS | EUS |
| EUS | EUS, EUN, CHN |
| EUS | EUS IB |
Can you confirm if this is what you want?
Hello,
Region will not be unique in the result. The Idea is to pick a value from 'Region' table and check in 'Consolidated Region', If this Region value is present in Consolidated value then Map consolidated value in front of Region value.
And this process should iterate over all the rows of 'Consolidated Region' column for each row of 'Regions' Column.
Yes at last we will have some duplicate rows in output table, but I'll remove it.