topic Table scan and joining column data in a sigle value. in DAX Commands and Tips

Table scan and joining column data in a sigle value.

Cipriano — Tue, 17 Oct 2023 17:12:56 GMT

Hello, everyone!

To check if it is possible to read a data table to obtain a summary view of the data, I basically need to integrate data using a table scan, joining the values of one of its columns:

Table Orginal

Fecha	Alumno	Materia	Comentario
01/01/2023	CLR	A	Puntualidad
01/01/2023	CLR	A	Tarea
01/01/2023	CLR	A	Retraso Ejercicio
01/01/2023	MRGM	A	Puntualidad
01/01/2023	MRGM	A	Tarea
01/01/2023	MRGM	A	Ejercicio

Result
Fecha	Alumno	Materia	Comentario
01/01/2023	CLR	A	Puntualidad, Tarea, Retraso Ejercicio
01/01/2023	MRGM	A	Puntualidad, Tarea, Ejercicio

Thank you very much in advance!

Re: Table scan and joining column data in a sigle value.

DallasBaba — Tue, 17 Oct 2023 21:09:44 GMT

Cipriano Yes, it is possible to group and concatenate text values using dax expression. Your final report will display the summarized view of the data with comments concatenated for each unique combination of "Fecha," "Alumno," and "Materia."

Concatenated Comments =
VAR GroupedData =
SUMMARIZE(
OrginalTable,
OrginalTable[Fecha],
OrginalTable[Alumno],
OrginalTable[Materia],
"ConcatenatedComments",
CONCATENATEX(VALUES(OrginalTable), OrginalTable[Comentario], ", ")
)
RETURN
MAXX(GroupedData, [ConcatenatedComments])

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.