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
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

Anonymous,

 

You may use code below.

if Text.Trim([Column1]) = "" then
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks Sam, will try that. outr of curiosity how would you reference th blank cell when using the conditgional column wizrd in Power Query

    • 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