Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Phone Number format

Hello,   I am trying to create a flag to determine what phones numbers are valid and invalid. The Dax that I'm using accounts for length and for any characters that are not numbers, and it works. H...
Need Help
  • ddpl's avatar
    ddpl
    4 years ago

    Anonymous 

    Try this

     

     

    Please as Accept as Solution if its worked.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for your help!  Unfortunetly, it didn't work for me. The "true" flag also captured numbers that were valid not just the invalid (999-999-9999)

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Anonymous 

 

Do you mean phone numbers like 999-999-9999, 954-111-1111, 999-123-3455 are all invalid phone numbers that should be flagged as False? Can you explain the rules of an invalid phone number while its format is correct? 

 

Best Regards,
Community Support Team _ Jing