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.
Hello, how to simplify the function if the query? (Table.AddColumn) too lazy to write up to 20 function attachments if
let Souce= {"power querry","poweer query","pooower que1ry"}, #"Table.FromList" = Table.FromList(Souce, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Table.AddColumn" = Table.AddColumn(Table.FromList, "Group", each if Text.Contains([Column1],"power") then "power" else if Text.Contains([Column1],"query") then "query" else null) in #"Table.AddColumn"
Solved! Go to Solution.
Seems that you're looking for a partial-match-lookup, where you can put your search-values in a table. Please check this post:
https://community.powerbi.com/t5/Desktop/joinAlgorithm-and-keyEqualityComparers/m-p/182148#M79842
Imke Feldmann
www.TheBIccountant.com -- How to integrate M-code into your solution -- Check out more PBI- learning resources here
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Seems that you're looking for a partial-match-lookup, where you can put your search-values in a table. Please check this post:
https://community.powerbi.com/t5/Desktop/joinAlgorithm-and-keyEqualityComparers/m-p/182148#M79842
Imke Feldmann
www.TheBIccountant.com -- How to integrate M-code into your solution -- Check out more PBI- learning resources here
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
It works, but it's very slow for my table (100,000 lines of the Product Reference), taking into account the links. Are there any other options?
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 |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |