Dax function to categorize based on number of characters.

[Nanakwame]

Hi Power query experts,

I have a column that contains an extension number. For instance 100, 200, 12438976, 9872177654, ###, etc.

I will like a dax function to count the number of characters and categorize into "internal" or "external". 

so the calc should be something like this. if the number of characters is greater than 10 then "internal" else "external".

Is there a function i can use to generate this logic. 

Thank you 

[Nanakwame]

Thank you Sir. Talk to you soon

[TheoC · Accepted solution]

@Nanakwame you can use the following as a measure or column:

Measure = IF ( LEN ( 'Table'[Column] ) > 9 , "Output 1" , "Output 2" )

Hope all is well mate.

Speak soon 🙂