Forum Discussion

Loveflora1229's avatar
Loveflora1229
New Member
3 years ago
Solved

Why can't I replace blank cells with null in PowerBI query

Dear all,

        I was following the step regarding replace blank cells with null but I don't understand why nothing changes? I will attach the screenshop below. Thank you. 

ps: there is indeed 'a space' in the 'value to find' section. 

 

 

Need Help
Show and Tell
Tutorial Requests
  • Alf94's avatar
    Alf94
    3 years ago

    Hi Loveflora1229 ,

     

    Try not to put spaces in the "value to find" section. Does this work?

     

    If I answered your question, please mark my post as a solution.

     

    Best,

3 Replies

  • Alf94's avatar
    Alf94
    Icon for Solution Supplier rankSolution Supplier
    3 years ago

    Hi Loveflora1229 ,

     

    Try not to put spaces in the "value to find" section. Does this work?

     

    If I answered your question, please mark my post as a solution.

     

    Best,

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Try using Replacer.ReplaceText instead of Replacer.ReplaceValue.

     

    --Nate