Forum Discussion

Creature's avatar
Creature
Frequent Visitor
1 year ago
Solved

Extract text before delimiter in fabric using DAX.

Hey All,   I have a column that is ticket numbers like SCTASK0012345, WKR0012345 etc. I need to extract all the text before the numbers to create a column for "Ticket Type". This data set comes fro...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    Hi,

    Try something like below whether it suits your requirement.

    It is for creating a calculated column.

     

    TicketType =
LEFT ( query1[Number], SEARCH ( 0, query1[Number] ) - 1 )

     

     

Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
1 year ago

Hello Creature,

 

Can you please try this approach:

TicketType = 
VAR FirstDigitPosition = 
    MINX(
        FILTER(
            GENERATESERIES(1, LEN('query1'[Number])),
            MID('query1'[Number], [Value], 1) >= "0" && MID('query1'[Number], [Value], 1) <= "9"
        ),
        [Value]
    )
RETURN
    LEFT('query1'[Number], FirstDigitPosition - 1)