Converting numbers to text?

[Anonymous]

Hi all ,

I want to combine 2 text fields and 2 number fields , but i keep getting the error Expression . Error :  We cannot convert the value to type Logical.

Some Raw Data :

TextField1	NumberField1	TextField2	NumberField2
India	4500	Apples	14749
US	6500	Nuts	65757
UK	8500	Peas	43442

I need to combine them to one column like :

India - 4500 - Apples - 14749

Any help appreciated, thanks.

[amitchandak]

@Anonymous , Try like

new column = [TextField1] & " - "& [NumberField1] & " - "& [TextField2] & " - "& [NumberField2]

[ryan_mayu]

@Anonymous 

Is this what you want?

Column = 'Table (2)'[Column1]&"-"&'Table (2)'[Column2]&"-"&'Table (2)'[Column3]&"-"&'Table (2)'[Column4]

[Anonymous]

Yes , but in power query , isnt this in DAX?

Sorry to not have mentioned that.

[ryan_mayu · Accepted solution]

@Anonymous 

please try this.

=[Column1]&"-"&Number.ToText([Column2])&"-"&[Column3]&"-"&Number.ToText([Column4])