question

SanaSheikh-7748 avatar image
0 Votes"
SanaSheikh-7748 asked DSPatrick answered

Power query extract values begin with number

Hi,

I am trying to extract values from a coulum which start with a number. I have been using this to extract the vlaues strating with specific number and it works (my first ever query i wrote ( if Text.StartsWith([Our Ref_1],"5") then [Our Ref_1] else null)))

But now my range it 0-9, it could be any number I want to extract whole value starting with number and I am struggling with the range.


[1]: /answers/storage/attachments/146578-image.png


I can't use modulo as my column has no pattern.

power-query-not-supported
image.png (448.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services


--please don't forget to Accept as answer if the reply is helpful--



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.