DAX Text - CONCATENATEX function


Advertisements

Description

Concatenates the result of an expression evaluated for each row in a table.

DAX CONCATENATEX function is new in Excel 2016.

Syntax

CONCATENATEX (
   <table>, <expression>, [<delimiter>], [<OrderBy_Expression1>], [<Order>] …
) 

Parameters

Sr.No. Parameter & Description
1

table

The table containing the rows for which the expression will be evaluated.

2

expression

The expression to be evaluated for each row of the table.

3

delimiter

Optional.

A separator to use during concatenation.

4

OrderBy_Expression1

Optional.

Column by which the values are to be concatenated.

5

Order

Optional.

ASC: To sort in an ascending order.

DESC: To sort in a descending order.

If omitted, default is ASC.

Return Value

A single text string.

Remarks

CONCATENATEX function takes as its first parameter, a table or an expression that returns a table.

The second parameter is a column that contains the values you want to concatenate, or an expression that returns a value.

Example

CONCATENATEX (Products, [Product],", ", [Product Key], ASC)
   returns Air Purifier, Detergent Powder, Floor Cleaner, Hand Wash, Soap.
   
= CONCATENATEX (Products, [Product],",", [Product Key], DESC) 
   returns Soap, Hand Wash, Floor Cleaner, Detergent Powder, Air Purifier. 

= CONCATENATEX (Products, [Product],", ", [Product Key]) 
   returns Air Purifier, Detergent Powder, Floor Cleaner, Hand Wash, Soap.
dax_functions_text.htm

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements