cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GuyAinley
Frequent Visitor

We cannot convert the value

I'm trying use Text.Combine to concatenate the values from two columns which are both text but I get the error

 

"We cannot convert the value "003011" to type List.
Details:
Value=003011
Type=[Type]"

 

Anybody any thoughts.

 

Thanks in advance

1 ACCEPTED SOLUTION
Jimmy801
Super User III
Super User III

Hello @GuyAinley 

 

Text.Combine takes a list and you are feeding it with a text-value. This is the problem. How are you referencing your two columns ? you need to have the result on row level? Then just use [Colunn1]&", " & [Column2]. 

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

View solution in original post

3 REPLIES 3
Jimmy801
Super User III
Super User III

Hello @GuyAinley 

 

Text.Combine takes a list and you are feeding it with a text-value. This is the problem. How are you referencing your two columns ? you need to have the result on row level? Then just use [Colunn1]&", " & [Column2]. 

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

View solution in original post

Thank you very much, that's worked for me.

negi007
Super User II
Super User II

@GuyAinley  Please check if there are no null values in your dataset. It is possible that null values might be preventing you from performing the task that you are trying to achieve. 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


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

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Kudoed Authors