The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Community ,
There are 2 tables which are joined by Column ID . I want to compare each cell value of Complaint Reference in table A against all values of Table B and if there is a match ( no need to be exact match , but even if some part of the string matches) , then I want to return ID column as an output from Table A .
Table A
Table B
Please assist with the requirement .
Thanks
Solved! Go to Solution.
There are multiple ways to achieve your desired result but you definitely cannot use a relationsip or LOOKUPVALUE as there is no exact match between the two columns in question. I have attached two sample pbix files - one uses power query, the other uses DAX (both calc column and measure)
I have atta
Proud to be a Super User!
There are multiple ways to achieve your desired result but you definitely cannot use a relationsip or LOOKUPVALUE as there is no exact match between the two columns in question. I have attached two sample pbix files - one uses power query, the other uses DAX (both calc column and measure)
I have atta
Proud to be a Super User!
Thank you @danextian . I Will look into this solutions and try them. Appreciate your help .
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
142 | |
109 | |
107 | |
76 | |
61 |
User | Count |
---|---|
276 | |
129 | |
124 | |
100 | |
89 |