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?
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.