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
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.

Forum Discussion

Concatenate text and numbers with Power Query

Related content

Concatenate date, number and letters in power query

Power query - concatenate text columns

Concatenate lists ;

concatenate strings

Concatenated Lookup