Forum Discussion
Helper IIITable scan and joining column data in a sigle value.
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!
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.
1 Reply
- DallasBaba
Skilled Sharer
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.