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.
Hola
Tengo un campo en Manager_Name de Power BI. Los datos están en el siguiente formato:
Manager_Name |
Ali Erik (202682) |
Organización (Lisa Anderson (205616) |
Organización (Amy Wang (152237)) |
Gato Gato (En licencia) |
Quiero eliminar el corchete y el número del archivo. Así que el resultado debe ser el siguiente:
Resultado |
Ali Erik |
Organización (Lisa Anderson |
Organización (Amy Wang) |
Gato Gato (En licencia) |
Traté de usar la siguiente expresión:
Text.Combine(List.RemoveItems(Text.ToList([Manager_name]),-"0"." 9"}))
pero sólo puede eliminar números, pero no corchetes "()".
Agradecería cualquier ayuda en esto.
Gracias
Rinku
Solved! Go to Solution.
Hola, @Rinku21 , es posible que desee probar
#"Added Custom" = Table.AddColumn(Source, "Custom", each Text.Replace(Text.Remove([Manager_Name], {"0".."9"}), "()", ""))
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hola, @Rinku21 , es posible que desee probar
#"Added Custom" = Table.AddColumn(Source, "Custom", each Text.Replace(Text.Remove([Manager_Name], {"0".."9"}), "()", ""))
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
@Rinku21, consulte si estos pueden ayudar. Es posible que haya obtener el número y volver aplecerlo con ""
https://radacad.com/remove-digits-or-keep-them-in-power-bi-using-power-query
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 |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |