Concatenate text and numbers with Power Query

[o59393]

Hi all

I am doing a concatenation of text and numbers with power query, the formula I use is:

if [#"[ L1.4 - Refillability ]"] ="Fountain" then [Refilability]&" "&[#"[L1.7 - Bev Category]"]&" "&[Size conversion]

else if [Container] = "TETRA" or [Container] = "CAN" then [Container]&" "&[#"[L1.7 - Bev Category]"]&" "&[Size conversion] 

else [Refilability]&" "&[Container]&" "&[#"[L1.7 - Bev Category]"]&" "&[Size conversion]

The error I get it is:

Expression.Error: We cannot apply operator & to types Text and Number.

The [size conversion] is in number format. I tried on my code number.toText ([Size conversion]) but still got an error.

How can I fix my code while leaving size conversion as number and not text?

Thanks.

[amitchandak]

@o59393 , Try using Number.ToText on numeric datatype

https://docs.microsoft.com/en-us/powerquery-m/number-totext

[Syndicate_Admin]

Thanks

[o59393]

Hi @amitchandak 

I did add it and got an error

if [#"[ L1.4 - Refillability ]"] ="Fountain" then [Refilability]&" "&[#"[L1.7 - Bev Category]"]&" "&Number.ToText([Size conversion])

else if [Container] = "TETRA" or [Container] = "CAN" then [Container]&" "&[#"[L1.7 - Bev Category]"]&" "&Number.ToText([Size conversion])

else [Refilability]&" "&[Container]&" "&[#"[L1.7 - Bev Category]"]&" "&Number.ToText([Size conversion])

Error is:

Thanks!

[v-juanli-msft · Accepted solution]

Hi @o59393 

Your [size conversion] is already a text column, please do not use "Number.ToText" before this column.

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