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.
Hi,
Probably an easy one but I can't find the solution. I have data imported from Google Analytics and I want to replace all values in the column 'Source' that contain varieties of LinkedIn to LinkedIn.
Is there an easy way to do this by replacing entire cell if it contains "inked" to "LinkedIn"?
I have doublechecked that the only sources containing 'inked' are from LinkedIn.
For example
be.linkedin
linkedin
nl.linkedin
touch.www.LinkedIn
Should all become
The reason I want a 'containing' solution is because I have a bunch of similar cases and I don't want to set seperate 'replace values' for all variances.
Thanks for any help!
Kind regards,
Tom Benders
Solved! Go to Solution.
You can create a new conditional column with the "contains" operator.
Thanks @Anonymous for your suggestion! Would have prefered to do this in the same column, but this works great too.
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |