Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Return number value before "-" in string

Hi Experts   How would you return the number value in the following string (need the left numbers before the "-") Column                       Result 0 - 1 week                   0 52 - 53 week ...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Anonymous ,

    I used the formula you mentioned and get the correct result.

    Not sure what error you have got by this formula.

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
4 years ago

Hi Anonymous ,

 

You can get this transformed in Power Query easily.

I am taking the data as you shared above as follows:

Now select your column and from the top ribbon Transform --> Extract --> Text Before Delimiter

A new window appears, where enter your delimiter as "-"  and then click OK

Finally you get the desired result:

Hope the solution helps.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Pragati 11 - firstly, apologies - this has to be a calculated column... My fault.. I can do this the PQ way...

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi - Have this but is noting working

    Sort_Bands = LEFT('reporting Diagnostics_Weekly_Waiting_MDS'[Wait_Bands],FIND("-",'reporting Diagnostics_Weekly_Waiting_MDS'[Wait_Bands])-1)
Related content