Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
JorgePereira
Helper I
Helper I

Resumir con texto

Hola a todos,

Tengo la tabla de abajo

ProductoCantidadTienda
Tomate10A
Zanahoria5A
Cebolla8A
Pepino12A
Tomate8B
Zanahoria2B
Zanahoria15C
Cebolla13C

y necesito la mesa final usando "Resumir"

¿Puedes ayudarme a unirme a las tiendas como en la siguiente tabla?

ProductoCantidadTienda
Tomate18A-B
Zanahoria22A-B-C
Cebolla21A-C
Pepino12A
1 ACCEPTED SOLUTION
fhill
Resident Rockstar
Resident Rockstar

¿Ha intentado utilizar el comando CONCATENATEX DAX? ¿Qué tal esto? (Lo sentimos, reemplace "," por "-")

Medida: CONCATENATEX( Vegs, Vegs[Store], ",")

fhill_0-1598474452597.png




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




View solution in original post

2 REPLIES 2
fhill
Resident Rockstar
Resident Rockstar

¿Ha intentado utilizar el comando CONCATENATEX DAX? ¿Qué tal esto? (Lo sentimos, reemplace "," por "-")

Medida: CONCATENATEX( Vegs, Vegs[Store], ",")

fhill_0-1598474452597.png




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




camargos88
Community Champion
Community Champion

Hola @JorgePereira ,

Pruebe este mcode:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCsnPTSzJV9JRMjQAEo5KsTrRSs6JRUX5JUCuKVzIPy8zPw/Is0AoKk0uzU1KLQJpNYKLwo0DKXRCNc0IU8gQZIMzig2GxhChWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Product = _t, Amount = _t, Store = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Product", type text}, {"Amount", Int64.Type}, {"Store", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Product"}, {
                                {"Amount", each List.Sum([Amount]), type nullable number},
                                {"Store", each Text.Combine([Store], "-"), type text}
                            }
                            
                            )
in
    #"Grouped Rows"

Capture.PNG



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.