Forum Discussion

PooBIDeveloper's avatar
PooBIDeveloper
Frequent Visitor
4 years ago

Dax Validation on PAN Data

Hi All,

Can any one help me to write Dax on Validation Of PAN no 

such as It should be 10 --using len()

Pan no consist of strings and Numbers(ie ABCDE1212Q)

first 5 will be string,the next 4 digit will be numbers and the last will be string.

Thanks

data
Validation

5 Replies

  • ValtteriN's avatar
    ValtteriN
    Community Champion
    4 years ago

    Hi,

    I wouldn't really do this in DAX since it is not really efficient to test datatypes within a string. For LEN you can used LEN but for mixed datatype things become a bit tricky. You could split your column by lenght in PQ and test the datatypes out of these new columns.

    • PooBIDeveloper's avatar
      PooBIDeveloper
      Frequent Visitor
      4 years ago

      Hi...

      I have tried the below dax but its shows only output as Invalid ..

      pan_val =
      VAR _Condition =
      (master_customer[LenPan] <= 10)
      && ISTEXT ( master_customer[First Characters] )
      && ISTEXT ( master_customer[Last Characters] )
      && ISNUMBER ( master_customer[Text Range] )
      RETURN
      IF ( _Condition, "Valid", "Invalid" )

    • v-kkf-msft's avatar
      v-kkf-msft
      Community Support
      4 years ago

      Hi PooBIDeveloper ,

       

      Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

       

      If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.


      Best Regards,
      Winniz