Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 DAX, but its also fine with whatever works.
I would like to join the Lectures tablesto the subjects table, which have no specific position of delimiter, only that lectures contain strings in subject.
Any help is highly appreciated.
Thanks
Solved! Go to Solution.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |