CONCATENATE - A function that joins two text strings into one text string. However, it lacks the dynamic capabilities needed for user input scenarios.

FORMAT - A function that converts a value to text according to the specified format. While useful for formatting, it does not support dynamic string concatenation based on user input.

COMBINE - A non-standard DAX function that is not recognized for string concatenation purposes.

STRINGJOIN - A function designed for dynamic string concatenation, allowing for the creation of custom strings based on user input or other variables, making it ideal for dynamic reporting scenarios.