Forum Discussion

TomLU123's avatar
TomLU123
Icon for Helper III rankHelper III
8 years ago
Solved

Validate the Data value with non-numerical characters

Dear experts,    I am building a report to validate report to validate the Participant ID stored in the Participant Table. I wish to add a custom column "Participant ID Validation Result" by checki...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago
    Column = IF(ISERROR(VALUE([Participant ID])),"Invalid","Valid")

    DAX 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago
Column = IF(ISERROR(VALUE([Participant ID])),"Invalid","Valid")

DAX 

TomLU123's avatar
TomLU123
Icon for Helper III rankHelper III
8 years ago

Hi Greg,

 

Just a follow up quesion if we use following condition:

If it is all number, the result will be valid. If it contains any non-numerical characters OR blank, it will show invalid.

NameParticipant IDParticpant ID Validation Result
Smith4222TInvalid
David Invalid
Jim5123同Invalid
Celia5922￥Invalid
Jessica52221Valid

 

In that case, how should we modify the DAX to achieve that?

Many thanks!

 

Greg_Deckler

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    I believe:

     

    Column = IF(ISBLANK([Participant ID]) || ISERROR(VALUE([Participant ID])),"Invalid","Valid")