Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Separating a Column that has Rows of Numbers and Rows of Strings

I have a data column that has a few rows with number values and a few rows with string values. Is it possible to seperate this column into two columns, one with numbers and one with strings. Here is a screenshot of my sample data.

 

 

 

I also want to keep the row in the same spot, so it is associated with the correct date, names, locations, and tasks.

General Comment
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi, 

     

    if you create a couple of calculated columns in report view you can use:

     

    Text =
    SWITCH (
    TRUE (),
    ISERROR ( VALUE ( 'Table'[Column1] ) ), 'Table'[Column1],
    blank()
    )
     
    Numeric =
    SWITCH (
    TRUE (),
    ISERROR ( VALUE ( 'Table'[Column1] ) ), blank(),
    'Table'[Column1]
    )
     

     

2 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Hi, 

     

    if you create a couple of calculated columns in report view you can use:

     

    Text =
    SWITCH (
    TRUE (),
    ISERROR ( VALUE ( 'Table'[Column1] ) ), 'Table'[Column1],
    blank()
    )
     
    Numeric =
    SWITCH (
    TRUE (),
    ISERROR ( VALUE ( 'Table'[Column1] ) ), blank(),
    'Table'[Column1]
    )