Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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!
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!