cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
advaith_mohan
Regular Visitor

Convert a column with numbers and text values to decimal values

Hi

I have an issue with converting the data type of a column. The column contains numeric values (decimals) and one text value (NA). I want to keep the NA's as that accurately represents the nature of the data. However, when I try to convert this column to fixed decimal, it returns an error for all text values. 

Is there a way that I can keep NA's and convert numeric values into fixed decimal type? 

Thanks!

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @advaith_mohan ,

 

Just as what @az38 mentioned, it is not supported in Power BI.

One workaround, create a measure like so:

Measure = 
VAR Data_ = SUM('Table'[Column1 - Copy])
RETURN 
IF(ISBLANK(Data_),"N/A",Data_)

NA.JPG

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

View solution in original post

3 REPLIES 3
Icey
Community Support
Community Support

Hi @advaith_mohan ,

 

Just as what @az38 mentioned, it is not supported in Power BI.

One workaround, create a measure like so:

Measure = 
VAR Data_ = SUM('Table'[Column1 - Copy])
RETURN 
IF(ISBLANK(Data_),"N/A",Data_)

NA.JPG

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

View solution in original post

az38
Super User II
Super User II

@advaith_mohan  no, there is no such way to get text value as any number


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
amitchandak
Super User IV
Super User IV

@advaith_mohan , one idea is to  extract number from it and mark the new column as decimal column. You have to add code to get decimal too

https://eriksvensen.wordpress.com/2018/03/06/extraction-of-number-or-text-from-a-column-with-both-te...

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors