Forum Discussion

yel4h's avatar
yel4h
New Member
11 months ago
Solved

[DAX] Dynamic way to get numeric values [0..9] from string with no pattern.

Hey, I have been wanting to make a DAX expression to solve this for a while. I saw a lot of others also struggle to do this with DAX and would have to use Power Query to solve. The following code...
Show and Tell
Tips and Tricks
  • yel4h's avatar
    yel4h
    11 months ago

    You are totally correct, I had comeback from a meeting and had forgot to change the code to refer to the virtual colum I created with addcolumn. 


    My intial test which works but can become concumption heavy, esp when strings are lenghty: 

    CONCATENATEX (
    FILTER (
        GENERATESERIES(1, LEN(txt)),
        MID(txt, [Value], 1) >= "0" &&
        MID(txt, [Value], 1) <= "9"
    ),
    MID(txt, [Value], 1),
    ""
)




     

v-karpurapud's avatar
v-karpurapud
Icon for Community Support rankCommunity Support
11 months ago

Hi yel4h 

We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

 

Thank You.