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 All
Please can you tell me how to remove the numbers that are embedded in a bracket including the brackets as well
e.g Looking at a country & its population, the data set has the following numbers
how do I remove these numbers including the brackets in power bi, whilst not using R
I am only interested in the population numbers.
Many thanks
Solved! Go to Solution.
Hi @atin ,
In the Query Editor, you could highlight the column "Population 2000 estimate" and Split the Column by Delimiter. Make the Delimiter "[" and the column should be split by the start of the Bracket.
From there you can go ahead and delete the second column that holds the rest of the Bracket and the number inside.
Let me know if this works for you!
Hi
In Power Query Designer you can select the value column and go to "Transform" - "Extract" - "Text Before Delimiter" and then add "[" as delimiter
At the top of the column where it says ABC, click and select number and see what affect that has on the result?
If that data has the [6] as part of the text, then that maybe related to an footnote, and you will need to strip it out, maybe using the SUBSTITUTE command?
Hi @atin ,
In the Query Editor, you could highlight the column "Population 2000 estimate" and Split the Column by Delimiter. Make the Delimiter "[" and the column should be split by the start of the Bracket.
From there you can go ahead and delete the second column that holds the rest of the Bracket and the number inside.
Let me know if this works for you!
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |