topic Dax Validation on PAN Data in DAX Commands and Tips

Dax Validation on PAN Data

PooBIDeveloper — Wed, 19 Jan 2022 11:02:40 GMT

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

Re: Dax Validation on PAN Data

ValtteriN — Wed, 19 Jan 2022 12:34:56 GMT

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.

Re: Dax Validation on PAN Data

AlexisOlson — Wed, 19 Jan 2022 16:13:35 GMT

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.

Re: Dax Validation on PAN Data

PooBIDeveloper — Thu, 20 Jan 2022 04:05:03 GMT

ok ValtteriN

Re: Dax Validation on PAN Data

v-kkf-msft — Wed, 09 Feb 2022 04:23:35 GMT

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

Re: Dax Validation on PAN Data

PooBIDeveloper — Mon, 14 Feb 2022 09:13:01 GMT

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