Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Frequent Visitor

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.


Frequent Visitor

ok ValtteriN

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,

Super User
Super User

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.

Super User
Super User


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.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


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] )
IF ( _Condition, "Valid", "Invalid" )

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Top Solution Authors