Dax Validation on PAN Data

[PooBIDeveloper]

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

[PooBIDeveloper]

ok ValtteriN

[v-kkf-msft]

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

[AlexisOlson]

I agree with @ValtteriN. This is possible in DAX but doing it in the query editor instead is much easier, especially if you use RegEx.

[ValtteriN]

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]

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" )