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?