Forum Discussion
Data cleaning with Power Query (Power BI)
Hello,
I have a problem with y data :
I import data and the problem is that the fields are preceded by spaces " ". My column is value therefore number, but Powerquery doesn't recognize them as such. (Like picture)
How can i clean the data, please ?
Thank you in advance
Hi ANB_13 ,
Create a manual step by pressing the fx in front of the formula bar.
This will return the PrevStepName, now copy this syntax behind it:
Table.ReplaceValue( PrevStepName, each [Net Value], each Number.From( Text.Trim( [Net Value] )), Replacer.ReplaceValue, {"Net Value"})
Cut the PrevStepName you've left in front of the syntax and paste it in place of, where it says PrevStepName in that code. That should do it.
Ps. Please mark this answer as solution when it helped you to resolve your question, thanks!
1 Reply
Hi ANB_13 ,
Create a manual step by pressing the fx in front of the formula bar.
This will return the PrevStepName, now copy this syntax behind it:
Table.ReplaceValue( PrevStepName, each [Net Value], each Number.From( Text.Trim( [Net Value] )), Replacer.ReplaceValue, {"Net Value"})
Cut the PrevStepName you've left in front of the syntax and paste it in place of, where it says PrevStepName in that code. That should do it.
Ps. Please mark this answer as solution when it helped you to resolve your question, thanks!