Concatenate values by dimension

[FrancescoSCP]

Hi all,

i have some data like this...

CUSTOMER  ACTIVITY  DESC

1                   AA            Started

1                   AA            Completed

2                   AA            Started

2                   AA            Waiting..

2                   AB            Stopped

I want to create a matrix wiew that has customers on rows and activities on columns.

On values i want to put concatenation of DESC field.

For example

Is there a function in Power BI or some DAX to concatenate those strings?

Thanks,

Francesco

[parry2k]

@FrancescoSCP try this measure, change table and column name as per your model.

My Desc = CONCATENATEX ( Test, Test[Desc], ", " ) 

Add matrix visual with following columns

[PaulDBrown · Accepted solution]

@FrancescoSCP @parry2k 

To add to parry2k solution, you might need to add a VALUES around the table reference in the measure, to avoid repetition of values 

ie:

My Desc = CONCATENATEX(VALUES(Test[Desc]), Test[Desc], ", ")

[FrancescoSCP]

EDIT: My error, i created a column and not a measure. Now it works good..THANKS!

I've tried your suggestion but something is not working properly.

I have this data:

and loaded into Power BI, then created this Column

Description = CONCATENATEX(VALUES(Activities[Desc]);Activities[Desc];UNICHAR(10))

Then created a Matrix with this new column, but it repeats for every Customer-Activity the same description:

The goal is to show the activities related to customer/activity.

Any suggestion?

Thanks,

Francesco

[PaulDBrown]

@FrancescoSCP 

Can you try the formula as a measure instead of a column?

[FrancescoSCP]

Hi,

thanks guys, i will test this and let you know..

Regards,

Francesco