Power BI Transform Phone Number

[aakashlakhani]

Hi I have a dataset contains phone numbers. I need to remove the 3 digits and space for a row to transform it to a standard  using Power BI. Can anyone help on this. 

Phone Numbers	Results
123-234-1234	123-234-1234
123-234-1235	123-234-1235
123-234-1236	123-234-1236
123-234-1237	123-234-1237
123-234-1238	123-234-1238
123-234-1239	123-234-1239
122 123-234-1240	123-234-1240
123-234-1241	123-234-1241
123-234-1242	123-234-1242
123-234-1243	123-234-1243
123-234-1244	123-234-1244
123-234-1245	123-234-1245
123-234-1246	123-234-1246
123-234-1247	123-234-1247
123-234-1248	123-234-1248
123-234-1249	123-234-1249
123-234-1250	123-234-1250
123-234-1251	123-234-1251
123-234-1252	123-234-1252

Thanks 

[praiselyabraham · Accepted solution]

Hi,

You can try something like: 

Result = RIGHT([Phone Numbers],12)

this shall get 12 charecters (10 number , and - twice)

Hope this shall fix your issue.

If this solves your concer, kindly approve this as solution and also a thumps up 🙂

Regards,

Praisely

[aakashlakhani]

Thanks