Forum Discussion

aakashlakhani's avatar
aakashlakhani
Frequent Visitor
8 years ago
Solved

Power BI Transform Phone Number

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 ...
Need Help
Tutorial Requests
  • praiselyabraham's avatar
    praiselyabraham
    8 years ago

    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

praiselyabraham's avatar
praiselyabraham
Resolver II
8 years ago

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's avatar
aakashlakhani
Frequent Visitor
8 years ago

Thanks