Forum Discussion
Solved
DAX Studio: Group by/Concatenate(Textcombine, listagg..) Script
Hello, I've got a massive table I've cleaned using Power BI. The scenario looks something like this: Column A Column B Column C 1234 Red Master 1234 Red Draft 1235 Blue ...
Try following
EVALUATE
SUMMARIZECOLUMNS (
Table1[Column A],
Table1[Column B],
"Column C", CONCATENATEX ( VALUES ( Table1[Column C] ), Table1[Column C], "," )
)
Zubair_Muhammad
Community Champion
Community Champion
Try following
EVALUATE
SUMMARIZECOLUMNS (
Table1[Column A],
Table1[Column B],
"Column C", CONCATENATEX ( VALUES ( Table1[Column C] ), Table1[Column C], "," )
)
Hi Zubiar,
Top notch. It worked!
Thank you!
Jq