Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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 @Anonymous ,

 

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 @Anonymous ,

 

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.

az38
Community Champion
Community Champion

@Anonymous  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
Super User

@Anonymous , 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-text-and-number-powerquery-powerbi/

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.