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),
    ""
)




     

yel4h's avatar
yel4h
New Member
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 

Thank you for the update and for sharing the details of your initial approach. Could you please confirm if the issue has been fully resolved after using the virtual char column as suggested by danextian ? If you have any further questions or need additional clarification, please feel free to let us know and we will be happy to assist you further.

Regards,
Microsoft Fabric Community Support Team