Find number with repeated digits in a column

[Dee]

Hi all,

I'm trying to find a way to identify numbers with repeated digits ina column

eg:

122234556 - meets criteria

123456 - doesn't meet criteria

112334556677899- meets criteria

020003445566 - meets criteria

01235679 - doesn't meet criteria

I can't seem to find a way to do this, any help on how to achieve it will be highly appreciated.

TIA!!

[az38 · Accepted solution]

@Dee 

try a column like

Column = 
var _withinText = CONVERT('Table'[Column1], STRING)
RETURN
IF(
SEARCH("00", _withinText,, 0) > 0 || SEARCH("11", _withinText,, 0) > 0 || SEARCH("22", _withinText,, 0) > 0 || SEARCH("33", _withinText,, 0) > 0 || SEARCH("44", _withinText,, 0) > 0 || SEARCH("55", _withinText,, 0) > 0 || SEARCH("66", _withinText,, 0) > 0 || SEARCH("77", _withinText,, 0) > 0 || SEARCH("88", _withinText,, 0) > 0  || SEARCH("99", _withinText,, 0) > 0,
"meets the criteria",
"doesn't meet criteria")

[Dee]

wow @az38 thank you so very much this is pretty much what I was looking for.

Supposing maybe just one repetition eg 1223456 is not enough how and 122223456 is what maybe I want to portray how do I twitch the formula.

ps// am accepting the solution.

[az38]

@Dee 

replace all SEARCH statements to statements like

SEARCH("222", _withinText,, 0)

 it depends on how many exactly repeats should be counted