topic CONCATENATE A PIVOT TABLE in DAX Commands and Tips

CONCATENATE A PIVOT TABLE

k1ko92 — Wed, 20 Apr 2022 15:50:59 GMT

Hi everyone,

Someone know how can i build this table concatenating all the information from column EVAL PENDIENTE, my unique key is the proyect (Proyecto)

PRUEBA LLENADO | DESARROLLO MONOGRAFIA | ENTREGA DE PLANOS | CREACION UPC | BRIEF LANZAMIENTO .....

amitchandak — Wed, 20 Apr 2022 16:20:34 GMT

k1ko92 , no very clear

a new table

summarize(Table, Table[protect], "_concat" , concatenatex(Table,Table[EVAL PENDIENTE]," ,") )

or measure in visual

concatenatex(Table,Table[EVAL PENDIENTE]," ,")

calculate(concatenatex(Table,Table[EVAL PENDIENTE]," ,") , allexcept(Table, Table[protect]) )

k1ko92 — Wed, 20 Apr 2022 18:26:55 GMT

It worked :)))))))), just a new doubt, how can i insert a filter inside of that ?

Summarize

FILTER - I need to summarize just for projects that have 100%.