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,
I have one field in Power BI 'Manager_Name'. The data is in below format:
Manager_Name |
Ali Erik (202682) |
Organization (Lisa Anderson (205616) |
Organization (Amy Wang (152237)) |
Cat Jack (On Leave) |
I want to remove bracket and number from the filed. So the result should be as below:
Result |
Ali Erik |
Organization (Lisa Anderson |
Organization (Amy Wang) |
Cat Jack (On Leave) |
I tried using below expression:
Text.Combine(List.RemoveItems(Text.ToList([Manager_name]),{"0".."9"}))
but it can remove only numbers but not brackets "()".
I would appreciate any help on this.
Thanks,
Rinku
Solved! Go to Solution.
Hi, @Rinku21 , you might want to try
#"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! |
Hi, @Rinku21 , you might want to try
#"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 , refer if these can help. You may have get number and replce it with ""
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |