Forum Discussion
Fali324
Helper II
Helper IIConcanate two columns based on a 3rd column
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.
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/
1 Reply
- tackytechtom
Most Valuable Professional
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/