Copy numerical values to new column from column that contains mixed numbers and text

[Anonymous]

Hi,

Started working with power bi not a long time ago, and I'm struggling with the following calculation:

I have a column that contains mixed numbers and text – all values in the column are text.

For example:

col

4

4

3

CDB

2

1

ABC

I need to copy the "numerical" values to a new column as numbers.

New_col

4

4

3

-

2

1

-

Unfortunatly In this model I can't use power query. 

Can anyone advise on how to resolve this?

Thank you

[rbriga]

If you have to do this in DAX (calculated column),

Add the column

 =IFERROR(VALUE([A]),BLANK())

Where [A] is the original mixed column.

[Anonymous]

Thank you for you response,
I wrote the query in Tabular editor (calculated column)- > 
IFERROR ( VALUE ( Fact_FormAnswerRows[Selected Answers] ), BLANK () )
And when I checked the results in PB the following error was showcased:

I'm not sure if there is something not current in my query or is it something else?

[rbriga · Accepted solution]

Refreshing didn't solve it?

Also, for testing, try doing the same outside of Tabular Editor.

[Anonymous]

Thanks!
In the end it worked 🙂