Help converting excel 'array formula'

[dpotta]

Hello

I'm sure this is an easy fix, but new to DAX and I hope someone can offer some advice!

In Excel [PC District] column has values like GU7, LS1, W1, B2, WF23. I use the formula below in a new column to find the numeric value and remove it so the new column reads GU, LS, W, B, WF


IFERROR(LEFT([PCDistrict],MIN(FIND({0,1,2,3,4,5,6,7,8,9}, [PCDistrict] &"0123456789"))-1),"")


DAX doesn't recognize { } as an array of numbers to find so how I would I express this function in DAX?

Many thanks

Dave

 

[Matt Allington]

I recommend you look at Power Query to clean your data before loading into power pivot. PP is a reporting tool, PQ is an ETL tool.

This may help. Keep Only Numbers in Power QueryThe Ken Puls (Excelguru) Blog