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.
Solved! Go to Solution.
Hey @Anonymous,
you can achieve what you want by marking the column inside Power Query, please be aware that the steps are "destructive", this means the original column will be "destroyed" by the following operations. If you want to keep the original column make sure you duplicate the column before you apply the following steps.
From the context menu choose "Split column" --> "By delimiter"
Choose the settings as below, just use the - instead of the h:
Hopefully, this is what you are looking for.
Regards,
Tom
Hi @Anonymous
You can just add a Custom Column with this 1 line (where Billing Code is the column name)
= Text.Start([Billing Code], Text.PositionOf([Billing Code], "-"))
regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Hey @Anonymous,
you can achieve what you want by marking the column inside Power Query, please be aware that the steps are "destructive", this means the original column will be "destroyed" by the following operations. If you want to keep the original column make sure you duplicate the column before you apply the following steps.
From the context menu choose "Split column" --> "By delimiter"
Choose the settings as below, just use the - instead of the h:
Hopefully, this is what you are looking for.
Regards,
Tom
User | Count |
---|---|
84 | |
81 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
105 | |
96 | |
86 | |
68 |