power query concat code example Example: power query concatenate = [TextColumn] & Date.ToText([DateColumn]) & Number.ToText([NumberColumn])