Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Arul
Super User
Super User

CONCATENATE AND CONCATENATEX

Hi,

Can someone explain what is the difference between concatenate and concatenatex?

 

Thanks,

-Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


3 REPLIES 3
Anonymous
Not applicable

Any of the functions that end in X are iterators, they loop over a list of values.  This means that you would pass in a column of values to CONCATENATEX and it would loop through the lists, and combine them togather into a single string.

 

CONCATENATE on the other hand simply combines 2 fields togather.

 

Here is some additional references:

CONCATENATE: https://dax.guide/concatenate/

CONCATENATEX: https://dax.guide/concatenatex/

 

MitchM
Resolver II
Resolver II

I'll try my best here. 

For A Table

CONCATENATE allows you to concatenate free text values, or column values (if wrapped in SELECTEDVALUE), or measure.

 

CONCATENATEX allows you to directly concatenate column values from the same row. 

 

For a Card

CONCATENATE will concat free text, or total measure values, but not Row Values (see pic)

CONCATENATEX will concat the row values and then delimit all values if a delimiter is specified

 

SQLBI is always a good place to go to for a little extra info: https://www.sqlbi.com/articles/using-concatenatex-in-measures/

Hope this helps.

CONCATENATEX_Test = 
CONCATENATEX(Table4, Table4[FirstName]&Table4[LastName],", ")

CONCATENATE_Test = 
CONCATENATE(SELECTEDVALUE( Table4[FirstName] ), SELECTEDVALUE( Table4[LastName] ))

Example.jpg

@MitchM ,

Thank you!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.