Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all,
If I have data such as: Walmart, Wal-Mart, Wal_Mart, WM, etc.... --- I want the end-user to be able to search "Walmart" and would like to include all these variations within this search.
1 -- Is there a method to 'bin' or 'group' spelling variations (into a new column)
2 -- Is the add-on 'SmartFilter' still the best method for the user to custom search?
Any information would be greatly appreciated!
Regards
Solved! Go to Solution.
I think you can only create a calculated column with SEARCH() function. See: From SQL to DAX: String Comparison
= IF ( SEARCH ( "Wal*Mart", Table[Column], 1, 0 ) > 0, 1, 0 )
Or you can do same string comparison with Text.Contains via Power Query approach.
There's no feature to detect the string on each row and create a group column automatically.
For custom search, using SmartFilter should be the best option.
Regards,
I think you can only create a calculated column with SEARCH() function. See: From SQL to DAX: String Comparison
= IF ( SEARCH ( "Wal*Mart", Table[Column], 1, 0 ) > 0, 1, 0 )
Or you can do same string comparison with Text.Contains via Power Query approach.
There's no feature to detect the string on each row and create a group column automatically.
For custom search, using SmartFilter should be the best option.
Regards,
If you know the alternate spellings, you could add this to your power queries to do the clean up for you. Of course this would mean recording every single varient of all the names you wish to account for.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
81 | |
70 | |
49 |
User | Count |
---|---|
143 | |
124 | |
107 | |
60 | |
55 |