Concanate two columns based on a 3rd column

[Fali324]

Hi,

My data set is below:

Project Name	Type	Enabling
Project 1	Main	Demo
Project 1	Main	Piling
Project 1	Main	Soft Strip
Project 1	Trade	Demo
Project 1	Trade	Piling
Project 1	Trade	Soft Strip

I would like a measure which would give me the output below:

Project Name	Type	Enabling
Project 1	Main, Trade	Demo, Piling, Soft Strip

Any help will be much appreciated.

Thank you.

[tackytechtom · Accepted solution]

Hi @Fali324 ,

How about this?

Here the DAX for the two measures:

Measure1 = 
VAR _helptable =
SUMMARIZE (
    'Table',
    'Table'[Project Name],
    'Table'[Type]
)
RETURN
CONCATENATEX(_helptable, [Type], ",")

Measure2 = 
VAR _helptable =
SUMMARIZE (
    'Table',
    'Table'[Project Name],
    'Table'[Enabling]
)
RETURN
CONCATENATEX(_helptable, [Enabling], ",")

Let me know if this solves your issue 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/