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,
there is a strange space between my data which I have no clue how to remove:
I have tried several methods, yet none of them worked.
It causes that my data is defined as text, even though it's clearly numbers.
Here is the file for those who would like to get their head around it:
EDIT: LEFT and RIGHT dax funcitons is not an option as data is dynamic, hence the numbers will be left 2 for some numbers and left 1 for the others.
Solved! Go to Solution.
Have you tried clean in power query? Transform menu.
if that doesn't work, click one of the cells in Power Query so you see the text at the bottom of the screen. Copy the space character to the clipboard, then transform, replace values and paste the character.
Have you tried clean in power query? Transform menu.
if that doesn't work, click one of the cells in Power Query so you see the text at the bottom of the screen. Copy the space character to the clipboard, then transform, replace values and paste the character.
Many thanks @MattAllington,
your solution worked splendidly.
Heads-up: remember to "replace using special characters"
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |