Forum Discussion

ANB_13's avatar
ANB_13
Helper I
3 years ago
Solved

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 a...
Show and Tell
Tips and Tricks
Tutorial Requests
  • m_dekorte's avatar
    m_dekorte
    3 years ago

    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!

m_dekorte's avatar
m_dekorte
Resident Rockstar
3 years ago

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!