Forum Discussion

gaurav-narchal's avatar
gaurav-narchal
Icon for Helper I rankHelper I
5 years ago

Cell Validation - Should only have 3 Digit number

Hello   How can i do cell validation to check if the value updated in the column (Number) is 3 digit number using a measure. Else it should return as a error.   Thanks   Product Number D...
Need Help
Show and Tell
jonoling's avatar
jonoling
Frequent Visitor
5 years ago

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!!