Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I've column with Country names listed as "Hong Kong Geo", Japan Geo", etc. I need help on creating a new column with only country names like "Hong Kong", "Japan" etc.
Any help on this would be appreciated.
Solved! Go to Solution.
@Anonymous
You can do it in Power Query, Under Add Column Tab > Extract and choose Before Delimiter, Leave one space and type Geo in Delimiter, press ok
Result
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Anonymous ,
You can also create a calculated column like so:
Column = LEFT([Country names],LEN([Country names])-4)
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Hi @Anonymous ,
You can also create a calculated column like so:
Column = LEFT([Country names],LEN([Country names])-4)
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
@Anonymous
You can do it in Power Query, Under Add Column Tab > Extract and choose Before Delimiter, Leave one space and type Geo in Delimiter, press ok
Result
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |