Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Need help on creating a calculated column

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.

2 ACCEPTED SOLUTIONS
Fowmy
Super User
Super User

@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

 

Fowmy_0-1604573609206.png

 

Result

Fowmy_1-1604573669517.png

________________________

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 🙂

YouTube  LinkedIn

 

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

Icey
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
Icey
Community Support
Community Support

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.

Fowmy
Super User
Super User

@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

 

Fowmy_0-1604573609206.png

 

Result

Fowmy_1-1604573669517.png

________________________

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 🙂

YouTube  LinkedIn

 

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.