Dax Expression to concatenate and group by

[kampyy]

ID	Sub ID	Sub Level
1	1	level 3
1	2	level 2
2	3	level 3
3	4	level 3
3	5	level 1
4	6	level 3
5	7	level 2
6	8	level 2

Looking for DAX Expression to - create a comma separate column of "Sub Level" group by "ID"

For EX.

ID	Sub ID	Sub Level	New Column
1	1	level 3	level 3, Level 2
1	2	level 2	level 3, Level 2
2	3	level 3	level 3
3	4	level 3	level 3, Level 1
3	5	level 1	level 3, Level 1
4	6	level 3	level 3
5	7	level 2	level 2
6	8	level 2	level 2

Thanks in Advance

[amitchandak · Accepted solution]

@kampyy , A new column

concatenatex(Filter(Table, [ID] = earlier([ID]) ) , [Sub Level] )

Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24

[Krutika124]

I have below data 

Run	RUNID	Job TerminalState	time
XYZ	1	Failed	Thu, 13 Feb 2025 13:19:05
XYZ	2	Failed	Thu, 13 Feb 2025 13:03:42
XYZ	3	Success	Fri, 07 Feb 2025 07:21:55
XYZ	4	Failed	Fri, 07 Feb 2025 07:07:52
XYZ	5	Failed	Wed, 05 Feb 2025 15:43:51
XYZ	6	Success	Fri, 17 Jan 2025 07:38:35
XYZ	7	Success	Fri, 17 Jan 2025 07:35:55

I need below output, Job terminal state will be recent 5 states to show in single row like below

Run	Job TerminalState
XYZ	Failed Failed Success Failed Failed

[v-cgao-msft · Accepted solution]

Hi @kampyy ,

Made some edits, added separator parameter (",").

Column = CONCATENATEX(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])),'Table'[Sub Level],",")

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[amitchandak · Accepted solution]

@kampyy , A new column

concatenatex(Filter(Table, [ID] = earlier([ID]) ) , [Sub Level] )

Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24

[UserSam123]

Hello,

Is it possible to make your formula dynamic in a measure?