cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shortmeister1 Frequent Visitor
Frequent Visitor

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:

 

Missing.png

 

 

This is what I believe that I should see:

Found.png

 

Can anyone help in finding the missing functionality?

 

Thanks

5 REPLIES 5
Stachu Super Contributor
Super Contributor

Re: Add Conditional Column Power Query Excel 2016 - Missing Options

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Shortmeister1 Frequent Visitor
Frequent Visitor

Re: Add Conditional Column Power Query Excel 2016 - Missing Options

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

Stachu Super Contributor
Super Contributor

Re: Add Conditional Column Power Query Excel 2016 - Missing Options

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
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Highlighted
Shortmeister1 Frequent Visitor
Frequent Visitor

Re: Add Conditional Column Power Query Excel 2016 - Missing Options

Hi

Definitely Windows 10.

I've unsatisfactorily fixed it. With my infrastructure guy in, I had a few more options.

Upgrading the application made no difference, so I uninstalled and loaded the (slightly hated) 365 version which had all the functionality but buttons still in slightly shifted positions.

The manual formula is a good tip.

This has been a baptism by fire, but so so useful.
Shortmeister1 Frequent Visitor
Frequent Visitor

Re: Add Conditional Column Power Query Excel 2016 - Missing Options

I will try tech net. It's a good shout.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 483 members 4,511 guests
Please welcome our newest community members: