latdelight.blogg.se - Excel 2016 power query update

#Excel 2016 power query update how to#
#Excel 2016 power query update update#
#Excel 2016 power query update full#
#Excel 2016 power query update code#

To be fair, Excel 2016 subscription customers are now receiving updates regularly. I'd be somewhat careful with that statement, as there is actually a lot going on here, with a lot of pressure from external sources that have driven Microsoft this way. You can find the installers I have in my forum here: You can pick it up from Microsoft’s site here: Īlso, I’ve started holding on to the previously released installers should you ever need to regress to a prior version.

#Excel 2016 power query update update#

Download the June 2016 Power Query update So as long as your logic needs are fairly simple, you can use this feature. You also aren’t obligated to feed out a column’s value, but rather can feed out text or values too.

#Excel 2016 power query update code#

You can test if one column compares (match, doesn’t match, greater than, etc) another column or specific value without having to manually write any M code formulas. I have suggested to Microsoft that they need a button to return is to the previous interface for this scenario.ĭespite the shortcomings, we should recognize that this is a great new feature. So if you want to modify that formula to be more complex than this new interface allows, you’re now going to have to go to the Advanced Editor window. You then committed it and want to change the logic, so you click the gear icon in the applied steps window… and you’ll be taken to the Conditional Column interface shown above, not the original window where you can create more complex logic. Assume you created a custom column using the “Add Custom Column” button, and manually wrote your “if then else” formula.To do that you’ll still need to create your own custom column formula using the “try otherwise” formula. You can’t provide IFERROR style logic to check if something errors and react accordingly.(Instead I’ll get text.) To do that you’ll still need to write your formulas manually. So if I wanted to check a column and return * in one case and *1.5* in others, it won’t work.

#Excel 2016 power query update full#

You can only feed out full columns as outputs, not formulas/equations.

Full caveat here: this is the image from the official Microsoft blog, not one of mine, but it shows you the general idea:Īs cool as this is, there are some issues here: This is also a pretty cool feature, as it lets a non-coder build an if then else (if) statement. This one feature is, in my opinion, worth the upgrade. Very visual, and very badly needed for a long time. That one needs attention as indicated by the question mark. Notice how easy it is to tell that the “Client, Task and Notes” fields are text (as shown by the ABC icon in the column header.) Hours is a decimal number, rate is a whole number, and Date… is undefined. We can now plainly see which columns have been defined with each data type: And if you haven’t… hopefully this will help ensure you don’t. If you’ve ever been burned by an “any” data type, you know why. The reason is that this has been a deadly area of weakness since day one. This is BY FAR the most important of the upgrades. Pretty handy for keeping things organized.

#Excel 2016 power query update how to#

PS, if you don’t know how to group your queries, right click on one, say “Move to Group” and select New Group. Time & resources is the answer, but it’s now working the way you’d expect it to work. This is great… so great in fact, that the only real question is why it hasn’t worked in the past. Personally, I would have rather seen them give me a feature to “pin” the Queries pane open and set that as a default, as I find the navigation from that area much more useful: But we can get to all these features by right clicking the query in the Queries pane on the left of the editor. Honestly, to me this is kind of a throw away waste “button for the sake of a button” kind of feature.ĭoes it make things more discoverable? Maybe. Microsoft has a blog on this here, but let me hit these quickly in reverse order to give my comments as well: Query Management Menu in Query Editor

Reorder Queries and Query Groups inside Query Editor via drag and drop gestures.

Column type indicator in Query Editor preview column headers.

What’s new in the June 2016 Power Query Update Even though there are only four items on the list of new features, some of them are quite impactful.

Yesterday, Microsoft released the June 2016 Power Query update.