Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Separate String and Numbers in the same column but diff rows

Just started learning Power BI   I have a column where the values got mixed in with the name instead of just SKU numbers. How do I separate the value of this column to 2 new ones . So basically the...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous you can add two new columns as per below DAX Expression:

     

    Product SKU Revised = IFERROR(VALUE( 'Table'[Product SKU] ),BLANK())

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

     

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous you can add two new columns as per below DAX Expression:

 

Product SKU Revised = IFERROR(VALUE( 'Table'[Product SKU] ),BLANK())

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