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?

With all the queries on the internet, we assume there is no built-in option to prevent pivot tables from overwriting data beneath the table during refresh and expansion. Is that correct?

Given that Excel has options for 'inserting' rows, why in the world would Microsoft NOT provide a pivot table expansion/contraction option for inserting or deleting rows from within the refreshed table without overwriting data beneath or to the right of the table?

It is also interesting that inserting rows into a regular Excel table, using the TAB key in the last row, can add rows by expanding the table without overwriting the data beneath. Yet, it will fill in any blank rows first before shifting down the data rows beneath the table.

Given the many requests for this option, we are surprised that Microsoft has not responded to this request.

Currently, the only way to add a PivotTable or PivotChart that is based on the Data Model is to use the "PivotTable" button in the Home tab of the Power Pivot window. This button should also appear in the Power Pivot tab in Excel's Ribbon.

When I work with Power Pivot, I'll do all of the Data Model work first, using only a few PivotTables for debugging purposes, and once I am confident that everything is correct, then I'll go crazy with making all of the final PivotTables and PivotCharts. This involves a lot of back-and-forth with the Power Pivot window. Also, when I think of adding a PivotTable, I think of where it is going, not what it is based on, and so I mistakenly go to the Excel window to try to add a PivotTable, only to go back to the Power Pivot window.

I'd like to think that there are more people that work in a similar way.

There are many aggregation iterator functions in DAX (SUMX, MINX, etc.). Their concept is the same: evaluate an expression for each row of a table and aggregate the results.

Instead of blowing up the function list with functions like these, there should either be a generic aggregation iterator function that accepts the aggregation function as an argument, or a generic iterator function that covers the iteration step but not the aggregation step (i.e. it returns a list of values to be fed to the "normal" aggregation functions).

The functions would look like this:
AGGREGATE(AggregationFunction, Table, Expression)
X(Table, Expression)

So instead of this:
SUMX(Table, Expression)
MINX(Table, Expression)

We would have this:
AGGREGATE(SUM, Table, Expression)
AGGREGATE(MIN, Table, Expression)
SUM(X(Table, Expression))
MIN(X(Table, Expression))

Once these functions are introduced, then SUMX, MINX, etc. can be deprecated.

The AGGREGATE function would also allow the aggregation type to be easily toggled/selected (using slicers and SWITCH) without repeating the Expression argument for each desired aggregation type and without using calculation items or calculation groups (which are still years away from being included in Power Pivot, if ever).

Many of the aggregation functions in DAX come in pairs. For example, SUM and SUMX, or MIN and MINX. The "not X" functions aggregate a single column and the "X" functions evaluate an expression for each row of a table and aggregate the results.

Using SUM as an example, why not just have SUM act like both SUM and SUMX and then SUMX can be deprecated? If the 1st argument is a column name, then it should act like SUM. If the 1st argument is a table, then it should act like SUMX.

This would greatly declutter the list of functions, both now and in the future, which, in turn, makes the language less intimidating, especially for beginners. If you are worried that multiple syntaxes will cause confusion, just remember that a similar idea is already used in the ALL function.

I want to be able to sort various values I have selected in my Pivot table in addition to the rows and columns.

For example, in a pivot table representing code coverage, I have class and function as my rows, for my values I have lines of code and the percentage of code touched. In order to see where I should best focus my efforts, I want to see the functions with the most lines of code and the least code coverage, so I want to sort first by LoC (descending) and then by coverage percentage (ascending).

This doesn't appear to have the votes reflecting it, but this is a very common search. Several examples of this ask (since as early as 2014...):

https://social.technet.microsoft.com/Forums/ie/en-US/10142054-a7a4-4aab-9142-c592f391d0ab/how-to-sort-pivot-table-on-multiple-columns?forum=excel

https://superuser.com/questions/1022547/cannot-sort-excel-pivot-table-by-two-or-more-columns

https://stackoverflow.com/questions/23499203/sorting-excel-pivot-tables-by-multiple-columns

There is also an additional UserVocie request on the Mac version:
https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/35493697-sort-on-multiple-columns-in-a-pivot-table-i-can-n

Can we please get support for this across all versions of excel? This has been a popular ask for quite a while.

Currently, the only way to move a measure to a different table is through the Manage Measures window, which is accessible from the Power Pivot tab in Excel. Also, the Manage Measures window lets you move only 1 measure at a time, which is a pain if you want to rename a Power Query table that is loaded to the Data Model, since you must move all of its measures to another table, rename the table, and move all of the measures back.

Please allow measures to be moved to different tables through the Diagram View in the Power Pivot window. Then I can select multiple measures, use Ctrl + X or right-click and Cut Measures, and then use Ctrl + V or right-click and Paste Measures to move multiple measures at once and quickly.