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.
cómo eliminar duplicados de una celda.
En el ejemplo siguiente "TELESCOPIC HANDLERS" es repetir los tiempos de servidor. ¿Cómo eliminar duplicados?
HI @santu1021,
Puede echar un vistazo a los siguientes métodos si cumplen con sus requisitos.
#1. Columna personalizada de consulta de energía:
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.Combine(List.Distinct(Text.Split([ProdcutType],",")),","))
#2. Columna calculada dax:
Distinct Product =
VAR _path =
SUBSTITUTE ( [ProductType], ",", "|" )
VAR _lengh =
PATHLENGTH ( _path )
VAR itemList =
DISTINCT (
SELECTCOLUMNS (
GENERATESERIES ( 1, _lengh , 1 ),
"ProductType", PATHITEM ( _path, [Value] )
)
)
RETURN
CONCATENATEX ( itemList, [ProductType], "," )
saludos
Xiaoxin Sheng
@santu1021 lo que esperas si hay dos valores distintos o nunca sucederá?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
¡¡¡Gracias!!! Quiero eliminar el texto repetido y me gustaría ver el texto una sola vez.
En Power Query:
1. Agregue un índice.
2. Divida en columnas en coma.
3. Despivote todas las columnas alrededor del índice.
4. Elimine los duplicados.
5. Gire de nuevo.
6. Retire el índice.
Al pivotar, utilice concatenación como función de agregación.
Mejor
D
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 |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |