Goal: Join text together.
CONCATENATE: Joins two specific strings.
CONCATENATEX: Iterates a table to list all values.
Ready...
💻 DAX Formula
-- Scenario 1: Join First & Last Name
COLUMN FullName =
CONCATENATE( First, CONCATENATE(" ", Last) )
-- Alternative: First & " " & Last
-- Scenario 2: List All Products Bought
MEASURE Product_List =
CONCATENATEX(
Sales, Sales[Product], ", "
)