Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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  
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, Anonymous ;

You could create a custom column as follow:

=Value.FromText ( [Column] )

 

The final show:


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's avatar
Anonymous
Not applicable
3 years ago

 

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

       

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    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.


    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.