cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bugs84 Frequent Visitor
Frequent Visitor

Concatenatex related distinct values

Hello everyone.

I have a measure in a table that gets the concatenation of values in a different table:

 

ListProductTypes = CONCATENATEX(Product;Product[ProductType];", ")

 

Work perfectly, but since I have many related Products (often with the same ProductType), I get an awful repetition of same values

 

e.c. Type1, Type1, Type2, Type2....

 

I only need to get (in this case) the distinct Type1, Type2

 

therefore i need something like ListProductTypes = CONCATENATEX(Product; DISTINCT ( Product[ProductType] ) ;", ")

 

but it doesn't work...

help would be appreciated

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Concatenatex related distinct values

@bugs84

 

Try chnaging the location of DISTINCT

 

ListProductTypes = CONCATENATEX(DISTINCT(Product);Product[ProductType]  ;", ")

 

 

or

 

ListProductTypes = CONCATENATEX(VALUES(Product);Product[ProductType]  ;", ")

 

4 REPLIES 4
Super User
Super User

Re: Concatenatex related distinct values

@bugs84

 

Try chnaging the location of DISTINCT

 

ListProductTypes = CONCATENATEX(DISTINCT(Product);Product[ProductType]  ;", ")

 

 

or

 

ListProductTypes = CONCATENATEX(VALUES(Product);Product[ProductType]  ;", ")

 

v-ljerr-msft Super Contributor
Super Contributor

Re: Concatenatex related distinct values

Hi @bugs84,

 

Have you tried the solution provided by @Zubair_Muhammad above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

 

If you still have any question on this issue, feel free to post here. Smiley Happy

 

Regards

bugs84 Frequent Visitor
Frequent Visitor

Re: Concatenatex related distinct values

Thank you very much!

I tried the first solution and it works perfectly! Woman Very Happy

mahdi1985 Visitor
Visitor

Re: Concatenatex related distinct values

Hi everyone,

I have a table:

 

Col1           ,Col2


a 1
b 2
c 3
a 4
b 5
c 6
a 7
b 8
c 9
d 10
e null
f null
g null


i want to concatenate the column Col2 to get:

a 1,4,7
b 2,5,8
c 3,6,9
d 4,7,10
e
f
g

Here is the formula i used: «CONCATENATEX(Merge1,Merge1[Col2],"; ")»

The result i get is:

a 1,2,3,4,5,6,7,8,9,10,,,
b 1,2,3,4,5,6,7,8,9,10,,,
c 1,2,3,4,5,6,7,8,9,10,,,
d 1,2,3,4,5,6,7,8,9,10,,,
e 1,2,3,4,5,6,7,8,9,10,,,
f 1,2,3,4,5,6,7,8,9,10,,,
g 1,2,3,4,5,6,7,8,9,10,,,

i'm not sure if i missed something

Thank you for your help,

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 305 members 3,305 guests
Please welcome our newest community members: