Forum Discussion

nat365's avatar
nat365
Frequent Visitor
2 years ago
Solved

Creating table with grouped data using DAX

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: ...
"DAX"
"Need Help"
  • sjoerdvn's avatar
    sjoerdvn
    2 years ago

    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], ","))
sjoerdvn's avatar
sjoerdvn
Solution Sage
2 years ago

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's avatar
nat365
Frequent Visitor
2 years ago

Thank you 🙂