Bring Power Pivot closer to Power BI Desktop Functionality
Development for Power Pivot for Excel seems to have stopped around 2016. TREATAS got added as a DAX function that works, but it never got added to Intellisense, and that was nearly 3 years ago.
Today, the two measure editors (still no idea why there are different ones) are a very VERY poor substitute for the fantastic DAX editor in Power BI Desktop. It is a real pain to properly tab and indent in the Excel Measure editor(s).
In the last year there have been about a dozen new DAX functions and several updated functions per https://docs.microsoft.com/en-us/dax/new-dax-functions but NONE of those are in Excel. I understand not all of them should be. APPROXIMATEDISTINCTCOUNT would have no relevance in Excel, but CONVERT, REMOVEFILTERS, CONTAINSSTRING, DISTINCTCOUNTNOBLANK, and others would all be useful to have.
We also cannot create tables in Excel using Measures.
Cannot enable bi-directional filtering. The CROSSFILTER function only helps with calculations, not slicers.
It seems really weird that Power Query in Excel is keeping pace with PQ in Power BI Desktop, other than missing many data sources, but internally functionality is pretty much on par, from functions to the UI.
Why is Power Pivot being seemingly left to wither on the vine?
Please keep the votes coming, so we can properly prioritize this against other potential feature work. The more detail folks can provide about the specific capabilities they need, the better we’ll be able to evaluate this work. Thanks!
David Milbrandt commented
I'd like to see more connectors for specific services in Excel. In Power BI I can just select Smartsheet, connect to the service, and then select the sheets I want to add. This same functionality is not just difficult but impossible in Excel.
I'd like to see Calculation Groups implemented in Excel version of DAX
Bill Schrank commented
Please update the Power Query editor (in Excel desktop) to show m syntax live (just like how the editor works in Power BI).
@Ed - Unlikely to happen.
The Fear of Excel in the Power BI team and the weak leadership in the Excel team will see Excel lagging far behind power BI Desktop in terms of the Mashup engine ,the Vertipaq Engine and the Visualization layer
Enrico Galli commented
Yes, please, don't leave us Excel users with this sort of half baked implementation, I really don't need power BI for most of my work. I understand the need to push the flagship BI software, but it has so much more than the basic functionality we ask to be able to build a proper model in Excel and analyze it with a pivot table
Ivan Bondarenko commented
I'm fully support the idea. So many scenarios for Excel with Power Pivot, where we don't need PowerBI. Pity to see that development of "power" part of Excel has stopped.
Wyn Hopkins commented
I'm on board with this
Let also add VAR and RETURN and be able to Right - Click add measures to a Measures Table.