Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 .....
Solved! Go to Solution.
@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]," ,")
or
calculate(concatenatex(Table,Table[EVAL PENDIENTE]," ,") , allexcept(Table, Table[protect]) )
@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]," ,")
or
calculate(concatenatex(Table,Table[EVAL PENDIENTE]," ,") , allexcept(Table, Table[protect]) )
Hi @amitchandak,
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%.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |