Forum Discussion
Similar Text Strings
I'm looking for a way to identify similar text strings within a column.
Picture for reference shows examples (highlighted yellow) of similar text strings. I'd like to be able to identify these strings and/or capture the similarity %.
Is this possible?
9 Replies
Anonymous
i think you will not be able to execute task like this in Power BI correctly
you need some other stating tool or script that will group your column by similarity
Not sure what your plan is once you find the similar ones, but I'm anticipating you'd like to group the results for similar rows together. There is a great feature you can use if so - grouping and binning. Please see this post to see if it helps you out.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
I am literally in the same exact boat, trying to identify similar supplier names in master data. I cannot use M / PowerQuery to transform and create columns, since my source data is a PBI dataset in Azure.
Any ideas on a way to do this in DAX?
I find myself in the same problem I want to find the similarities between strings of a column
I am here wondering on whether there was a solution to this question. I am also looking for something similar.
Have you tried fuzzy or approximate joins?
You would need to self join your column with itself.
If you need further details:
https://learn.microsoft.com/en-us/power-query/merge-queries-fuzzy-match
https://learn.microsoft.com/en-us/powerquery-m/table-fuzzyjoin
If anyone can help me, is there any way to get similarities rowwise comparing two columns?
