Before when Power Query was an add on in excel we used to have the attached Custom Column Wizard. But in Office 2016 we cannot find the same:
it is still there, check the following screenshot:
Whats your office version.
I am using Professional Plus 2016, and I don't see such an icon:
I see, mine is Office 365. Sorry for confusing you, I tought there isn't such a big difference.
Hi @mbuhary ,
By my tests with my version of excel, it seems that it has the option add consitional column.
In addition, I'm afraid that you'd better have a consult with the power query forum to get the most professional help.
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.