concatenate two columns in power bi query editor code example
Example: power query concatenate
= [TextColumn] & Date.ToText([DateColumn]) & Number.ToText([NumberColumn])
= [TextColumn] & Date.ToText([DateColumn]) & Number.ToText([NumberColumn])