Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

how to extract a value no numeric as alphanumeric ?

hi,   I look for a function for desktop and/or query   My goal is to extract a value no numeric to get in a new column as a type.  For instance    Number                                   New ...
Need Help
  • Gordonlilj's avatar
    Gordonlilj
    6 years ago

    Hi,

     

    You could try using the split function in power query. Perhaps by non-digit to digit would work in your case

     

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

You need to create 2 measures like below:

Number = IFERROR(VALUE( 'Table'[ColumnValue] ),BLANK())

Name = IF( ISERROR(VALUE('Table'[ColumnValue])), 'Table'[ColumnValue] )

 

Please give KUDOS to this effort and accept this as a solution!