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] )

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Where/How do you apply this DAX expression?

I am not in that topic yet

  • v-joesh-msft's avatar
    v-joesh-msft
    Solution Sage
    6 years ago

    Hi Anonymous ,

    As parry2k said, select -Modeling-New Column in the Data view and enter the formula:

    Best Regards,

    Community Support Team _ Joey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous add new calculated column in your table where your original data column is