Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
Here is my question,
I have a spreadsheet with different names attached to series of letters (see screen shot)
I want to associate these names to a slicer but without having to modify the original spreadsheet and manually delete the series of letters.
So for exemple in the next slicer I want to associate John SZ + John PPx to John
Thanks,
Nick
Solved! Go to Solution.
You can duplicate the column in Power Query. Then split that column by delimiter, and remove the misc column to have the following:
That assumes there is always a space between the Name and suffix
You can duplicate the column in Power Query. Then split that column by delimiter, and remove the misc column to have the following:
That assumes there is always a space between the Name and suffix
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |