Extract Phone Country Code Dax Formula

[Anonymous]

Hello Community,

I am building a Power Bi report and need to extract the phone country code from a text string. Text string is as follow:

"John Adams (34860721035)"

In excel I developed the following formula: MID(A2, FIND("(",A2, 1)+1, 2) and would obtain 34 from the Text string above. Sometimes text string is only composed of a first name and numbers length can vary depending on the country.

Any idea how I could replicate the excel formula in Power Bi Dax?

Thanks in advance

Thank you very much.

[v-yuta-msft]

@Anonymous ,

Generally, you may try DAX function 

LEFT(), LEN(), RIGHT()and MID() 

Regards,

Jimmy Tao