powerbi how to concatinate strings code example

Example 1: power query concatenate

= [TextColumn] & Date.ToText([DateColumn]) & Number.ToText([NumberColumn])

Example 2: power BI append string to calculated measure

Text Concat = 
"At " & 'ProductCatalog'[PriceDate] & " the Price was " & 'ProductCatalog'[Price]