Forum Discussion
benjamin_sasin
6 years agoResolver I
Replacing Blanks in Power Query inside a Table.ReplaceValue() function
I am trying to figure out how to replace blanks in Power Query, but all Google an Forum search lead me to using DAX, which is not what I am looking for, as I want to use Power M query. Also, searching for "blank" in the Power M Query documentation leads to nothing relevant.
I tried replacing "" with text, assuming "" is blank, but that somehow replaces the majority of rows and yet still leaves a couple of rows as "(blank)".
I'm using a Table.ReplaceValue() function. How can I replace blanks within that?
Thanks