Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Concatenate text and numbers with Power Query

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]"]&...
Need Help
Show and Tell
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
6 years ago

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's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

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.