PowerPivot formula to capture a string

[Mr.Karr]

Hello,

Can anyone please provide a formula which I can use in data model to populate string that appears before a oepn bracket. Say example;

Central and Eastern Europe (Area)
Central and Eastern Europe (Sub Region)
Russia (Region)

if you can provide a formula that rounds up before 'space' would also be great.

Many thanks in advance.

 

[Mr.Karr]

will this work?

=MID([GeographyGeography Hierarchy],1,FIND("(",[GeographyGeography Hierarchy],1)-1)

 

[Khalid NGO]

Hi,

Your formula seems ok.
You can also use left function:
=LEFT([GeographyGeography Hierarchy],FIND("(",[GeographyGeography Hierarchy],1)-1)

Without a sample, dont know how it works on PPT.
Regards,