Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"