Extracting English Names from Other Language Text Using DAX in Power BI
Extracting English Names from Other Language Text Using DAX in Power BI Dax Formula: EnglishName = VAR TextToSearch = 'YourTableName'[YourColumnName] VAR EnglishChars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ" VAR NameStart = MINX( FILTER( ADDCOLUMNS( GENERATESERIES(1, LEN(TextToSearch), 1), "Character", MID(TextToSearch, [Value], 1) ), CONTAINSSTRING(EnglishChars, [Character]) ), [Value] ) VAR NameEnd = MAXX( FILTER( ADDCOLUMNS( GENERATESERIES(1, LEN(TextToSearch), 1), "Character", MID(TextToSearch, [Value], 1) ), CONTAINSSTRING(EnglishChars, [Character]) ), ...