cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Arul Member
Member

CONCATENATE AND CONCATENATEX

Hi,

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

 

Thanks,

-Arul

3 REPLIES 3
MitchM Member
Member

Re: CONCATENATE AND CONCATENATEX

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

Arul Member
Member

Re: CONCATENATE AND CONCATENATEX

@MitchM ,

Thank you!

fenchurchio Regular Visitor
Regular Visitor

Re: CONCATENATE AND CONCATENATEX

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/

 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 198 members 2,645 guests
Please welcome our newest community members: