Forum Discussion
Create a relationship by matching strings between two columns from different tables
Hi everyone, I would like to create a relationship between two columns from different tables like in the attached screenshot. Ideally it would be nice to do it in power query, rather than using ...
Hi Anonymous
check this relative lookup by ImkeF
https://community.powerbi.com/t5/Desktop/joinAlgorithm-and-keyEqualityComparers/td-p/110108
- Text.Contains function for comparison
- Text.Lower function for text preparation
Hi Anonymous
check this relative lookup by ImkeF
https://community.powerbi.com/t5/Desktop/joinAlgorithm-and-keyEqualityComparers/td-p/110108
- Text.Contains function for comparison
- Text.Lower function for text preparation