Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
112 | |
96 | |
94 | |
64 | |
58 |