Creating table with grouped data using DAX

[nat365]

Hi All,

I would like to create table that summarize my data:

Name	Status	Code
Anna	Y	1
Anna	Y	2
Mark	Y	3
Anna	N	4
Anna	Y	2
Mark	Y	3

to following format:

Name	Codes
Anna	1, 2
Mark	3

So the task is to create column thats joins distinct values with Status=Y from column Code to one String for each value in column Name.

Do you know is it possible to create using only DAX?

[sjoerdvn · Accepted solution]

If you want to create a computed table, then use this (replace tbl with your table name)

SUMMARIZE(CALCULATETABLE(tbl, tbl[Status]="Y"),[Name],"Codes", CONCATENATEX(VALUES(tbl[Code]),[Code], ","))

[nat365]

Thank you 🙂