Search Digit

[toum]

Hello, 

Please I need your help on this I want to serach for the 4 first consecutive digit in a text using dax, here an exemple 

Thank you in advance

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://dropmefiles.com/iKZRG

If this post helps,
then please consider accepting it as the solution to help other members find it faster,
and give a big thumbs up.

[v-zhangti]

Hi, @toum 

You can try the following methods.
In the Power Query-Add Custom Column:

Text.Combine( List.Range(List.Select( Text.ToList(Text.Replace([Column]," ","")),each _<"A"),0,4))

Result:

Hope this method helps you.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.