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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Error in column

Hi,

 

I have a column formated as text with 2 types of data. 1) 12345 and 2) AB123. Now I am looking for a way to have them in same column without Error

 

thanks  

17 REPLIES 17
v-yalanwu-msft
Community Support
Community Support

Hi, @Anonymous ;

Is your problem solved?  If so, kindly mark the proper reply as a solution to  close the case. If not, let me know and I'll try to help you further.


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

my problem is not solved

Hi, @Anonymous ;

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft
Community Support
Community Support

Hi, @Anonymous ;

The same column can only have one type, because some values in a column in your data contain non-numeric characters, so it cannot be converted, if you can, can you give some examples and the result that this example hopes to output?

I don't  understand what you want to do.


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

i want to change type of column to any so it will remove the Error so it can read of them 
1) 12345
2) AB123.
thanks

v-yalanwu-msft
Community Support
Community Support

Hi, @Anonymous ;

You could create a custom column as follow:

=Value.FromText ( [Column] )

vyalanwumsft_1-1668583900942.png

 

vyalanwumsft_0-1668583886505.png

The final show:

vyalanwumsft_2-1668583919171.png


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

TarifAlanazi_0-1668933097305.png

 

Hi, @Anonymous ;

You could download this pbix. the result such as your said, Since I don't know if the specific operation of your file is consistent, I don't know the cause of the error, and if you can, you can only share the file.

vyalanwumsft_0-1669195298601.png


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Hi, @Anonymous ;

Can you share error details or simple files? Too little information is known through pictures.


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

TarifAlanazi_0-1669101210233.pngTarifAlanazi_1-1669101247629.png

 

Anonymous
Not applicable

 

0

Last Applied Step in your query, like Source, ChangedType etc.

Anonymous
Not applicable

TarifAlanazi_0-1668505729109.png

 

AntrikshSharma
Super User
Super User

@Anonymous Then you can add a new column and use Value.FromText.

Table.AddColumn ( PreviousStep, "TextOrInt", each Value.FromText ( [Column] ), type any )
Anonymous
Not applicable

TarifAlanazi_0-1668502377837.png

 

@Anonymous Read the error! You are missing closing parenthesis and what is your previous step? use that in the first argument.

Anonymous
Not applicable

TarifAlanazi_0-1668503895272.png

 what they mean about PreviousStep? 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.