Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all, I am trying to erase some characters in a column if they start with the specific letters: PCE-
And then I'd keep only the numbers after the -
How can I easily automate that for everytime the data is refreshed?
Thanks
Solved! Go to Solution.
In Power Query, create a new custom column like this:
Power Query has a number of different text functions available to manipulate your raw data.
Hope this helps.
Regards,
In Power Query, create a new custom column like this:
Power Query has a number of different text functions available to manipulate your raw data.
Hope this helps.
Regards,
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |