m query to combine two colums code example Example: power query concatenate = [TextColumn] & Date.ToText([DateColumn]) & Number.ToText([NumberColumn])