topic Re: Creating table with grouped data using DAX in DAX Commands and Tips

Creating table with grouped data using DAX

nat365 — Tue, 26 Sep 2023 10:00:43 GMT

Hi All,

I would like to create table that summarize my data:

to following format:

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 — Tue, 26 Sep 2023 15:34:15 GMT

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 — Mon, 02 Oct 2023 11:25:01 GMT

Thank you 🙂