Cell Validation - Should only have 3 Digit number

Hi gaurav,

You have two options:

1. Using Power Query, you can add a conditional column to the table:
   • If Text.Length([Number]) = 3 then True else False
2. Alternatively the LEN() function in DAX will also work as a new Calculated Column:
   • Cell Validation Check = IF(LEN(Table1[Number]) = 3, TRUE(), FALSE())

You can then filter by the new column to find cells with only 3 digits.

Hope this helps.

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

One thing to note is that this is impossible to achieve through a measure. Your requirement to validate the field row-wise. You should use custom columns for row-wise computations. Measures are meant to aggregate values over multiple rows.

Hi gaurav-narchal,

AFAIK, Dax expression and calculate fields can calculate with the raw field but not able to direct change raw field values.
In my opinion, I'd like to suggest you enter to 'query edit' side to do custom with the 'replace value' function to replace these no matched values.
Regards,

Xiaoxin Sheng