Power BI Transform Phone Number

Question

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 Answer

Hi,&nbsp;You can try something like:&nbsp;Result = RIGHT([Phone Numbers],12)&nbsp;this shall get 12 charecters (10 number , and - twice)&nbsp;Hope this shall fix your issue.If this solves your concer, kindly approve this as solution and also a thumps up :)&nbsp;Regards,Praisely

Forum Discussion

Power BI Transform Phone Number

2 Replies

Related content

Data transform using power query

Table Transformation

Transform columns / type

M Language Transformations

Transform to negative numbers