cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

Highlighted
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.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 387 members 3,950 guests
Please welcome our newest community members: