CODEWITHSUNDEEP
office365business-intelligencedaxpowerbi
Stephen King
Stephen King

Reputation: 836

Is column [x] number if so do convert to a number [y] or return blank

I have a really basic excel spreadsheet imported into PowerBI. Here is the data in powerBienter image description here

The response column will have either text a number in it. I need an additional column to covert it to either a number or return blank.

This is the formula i currently have:

Column = IF(ISNUMBER(Sheet1[Response]),VALUE(Sheet1[Response]),BLANK())

This always returns blank, and ISNUMBER(Sheet1[Response]) or ISNUMBER([Response]) always returns false.

Any ideas where i am going wrong here.

Upvotes: 1

Views: 74

Answers (2)

Stian
Stian

Reputation: 187

Well, I had this problem and clumsily did this, but it worked. 

Column = IFERROR(value([response]),blank())

Upvotes: 2

Balinti
Balinti

Reputation: 1534

Adding the value to the if statement will resolve number stored as text:

Column = IF(ISNUMBER(value(Sheet1[Response])),VALUE(Sheet1[Response]),BLANK())

Upvotes: 0

Related Questions