Forum Discussion
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 ...
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])
Thank you!