Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |