Forum Discussion

Impactful Individual

6 years ago

Solved

Power Query - Text.Contains on a Column of another Table

Hi Everyone, I have a following problem.. Consider 2 tables Course Master (about 1100 rows) - Only one column as Lecture Code (Contains unique values) Lecture Codes NIM1L4A NIM1L4H ...

Need Help

Zubair_Muhammad
6 years ago
ChandeepChhabra

Please see attached file with your data. Let me know if it is useful

Power Query - Text.Contains on a Column of another Table.pbix12.8 MB

Zubair_Muhammad

Community Champion

6 years ago

ChandeepChhabra

Please see attached file with your data. Let me know if it is useful

Power Query - Text.Contains on a Column of another Table.pbix12.8 MB

ChandeepChhabra

Impactful Individual

6 years ago

Thanks Zubair_Muhammad . Barring a few exceptions, it's almost there.

I'll fine tune it. Many thanks!

Forum Discussion

Power Query - Text.Contains on a Column of another Table

Related content

Table.Skip won't work with Text.Contains?

Sort by another column

Text.Contains form another query/table

Find Most Recent Date Relative to another Date Column in Power Query

list to filter column using Text.Contains function