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.
I'm trying to substitiue multiple values from a text column to use in a word cloud. Following this question I am able to filter out most the words I need. However, when I try to with "a", "i", "or", it will remove every every instances of that.
I.E. Have => hve
Alligator => llgt
What can I do to substitue every distinct instance of "a", "i", and "or" from a text column?
Thanks
zingwing
Solved! Go to Solution.
@Phil_Seamark If I use Replace Values in the query editor will it only run the replacement on existing data or will it also run on all future data?
The Query will re-run every time the data is refreshed. So the answer is yes, it will work on all future data.
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |