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 digi...
data
Validation
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

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.