Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello everyone,
I have a problem that needs to be solved. I need to be able to compare two columns in two different tables and see if there are similar strings within those two columns. So for example if I would like to compare a list of my friends to the most wanted lists of the FBI, I could do that.
So the pseudo code would look something like this:
For name in name_column in myfriends_table:
Compare the similarities of every name in myfriends[name_column] to the FBI's most wanted list name_column
return values that have similarities over 40%
Below I have a demonstration for my issue.
My Friends
Name |
TJ Watt |
Minkah Fitz |
Juju Smith-Schuster |
Big Ben Roeth |
FBI's Most Wanted
Name |
TJ Hatt |
Juju Smith-Schuster |
Juju Smith |
Cam Heyward |
Big Ben Roeth |
Results table
My Friends Name | FBI's Most Wanted Name | Similarity |
TJ Watt | TJ Hatt | 83,333% |
Juju Smith-Schuster | Juju Smith-Schuster | 100% |
Juju Smith-Schuster | Juju Smith | 46,67% |
Big Ben Roeth | Big Ben Roeth | 100% |
Is it possible in dax?
Kind regards,
Jeppe
Solved! Go to Solution.
Hi @Anonymous ,
You'd better first create a summarized table such as below:
As if you directly compare the characters from 2 tables,the calculation would be created in the table below:
After you get a summerized table,you could refer to below similar thread to realize what you need.
https://community.phttpsi.com/t5/Deskpowerbipare-t5o-strings-for-similarity/m-p/290062
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Have you checked my answer? Is your problem solved?
Saludos
Kelly
Have I answered your question? Mark my position as a solution!
Have you checked my answer? Is your problem solved?
Saludos
Kelly
Have I answered your question? Mark my position as a solution!
Hi @Anonymous ,
You'd better first create a summarized table such as below:
As if you directly compare the characters from 2 tables,the calculation would be created in the table below:
After you get a summerized table,you could refer to below similar thread to realize what you need.
https://community.phttpsi.com/t5/Deskpowerbipare-t5o-strings-for-similarity/m-p/290062
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
64 | |
52 | |
47 |
User | Count |
---|---|
216 | |
89 | |
76 | |
67 | |
60 |