Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Add Conditional Column Power Query Excel 2016 - Missing Options

Hi

 

I'm missing a key option from my Query Editor (Add Column on the Ribbon).

 

This is what I see:

 

 

 

This is what I believe that I should see:

 

Can anyone help in finding the missing functionality?

 

Thanks

Need Help

5 Replies

  • Stachu's avatar
    Stachu
    Community Champion
    7 years ago

    I'd try updating the Office, this is not a setting that you can enable/disable, it's just dependant on your PQ version

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      No such joy.  I updated Office this morning and it's still missing the functionality.

      • Stachu's avatar
        Stachu
        Community Champion
        7 years ago
        You are using Windows, not iOS, right? Does your company control the update version? I cannot think of any other reason for this to be missing if you use the latest version.

        You can still write the column manually with
        if ... then ... else ...
        In the add custom column window

        You can also try on Technet Excel Power Query forums, you may get more guidance there