Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Blanks in Conditional Column

Hi,   I have blanks in my column in the query and I am trying top use it in a conditional column.   What would the test be, it is not null as there is not a null in the column only a blank cell. ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    You may use code below.

    if Text.Trim([Column1]) = "" then
Adaric's avatar
Adaric
Microsoft Employee
6 years ago

I'm interested in how to do this via the Wizard as well

gidgetsMum's avatar
gidgetsMum
New Member
3 years ago

Use "null" in the wizard