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?

Hello,

Background

1. Create table:

|Date|Number|
|01.01.2020|10|
|02.01.2020|20|

1. Create pivot table based on table from p.1.


2. Drag field "Date" to rows of pivot table.


3. Drag field "Number" to columns.

Problem

1. Rename field "Date" to "Date 1".


2. Update Pivot Table.

Field "Data" has been removed from Pivot Table because it's been renamed to "Data 1". Now you need to manually add this "Date 1" back to Pivot Table.

Proposal

Based on example from "Background" and "Problem" sections:

1. Don't remove field from Pivot Table if it's been renamed.


2. Rename field in Pivot Table according to a new name in source table and don't change layout of a Pivot Table.

I often use Pivot for large datasets that also contain repeating non-numeric cell inputs.

If I want to know the sum of those non numeric inputs, there is no function currently that can do that.

Pivot needs to be able to give the user the sum of unique values, such as names, without adding other parts from data.

For example:
Drag some part of non numeric data (example: company names) to Pivot rows,

Pivot then gives the sum/is capable of giving sum of unique values without adding other data.
As a result it shows how many times the input (example:company name) appears in the dataset.

A common situation when working with Power Query and the Data Model is that a Power Query query loads data to the Data Model.

What can easily happen is that a mistake is made in Power Query, leading to an additional column (perhaps just a slightly mis-named version of an existing column) being included in the query result. The Data Model automatically adds this column to the corresponding table in the Data Model. However: when the user tries to correct her error in Power Query (removing the additional, erroneous, column), she gets a data load error when running the query: the Data Model reports that the column is missing.

Any attempt to remove the column directly in the Data Model leads to the message "this table is the result of a query, please modify the query instead". But as just described, modifying the query to remove the column leads to a data load error.

It is possible to delete the table from the Data Model and then re-load it. However, it is often the case when using a large fact table that there are then a large number of pivot tables in the workbook based on the Data Model fact table. Rebuilding all of these by hand is time-consuming and error-prone.

Hence the wish to be able to manually delete a column in the Data Model, or to reduce the data load error ("Column X could not be found") to a warning ("Column X was not included, should it be deleted from the Data Model").

This was requested on Dec 15: "I would like the default on pivot tables to go to "Sum" rather than "Count" or have an option for the user to select what the default is."

Request was declided on Jan 13 as the default settings and handling is defined and deemed appropriate.

The "bug" that people are dealing with is however: when a blank is part of the numerical dataset over which a pivot table is created, the ruling now defaults to count rather than sum. It would be better if the source cell is numeric, yet blank (empty), the default output in the pivot is still sum. Then the issue is resolved.

Also - it would be handy if pivot field settings can be changed on a manually selected groups of pivot fields (rather than one by one).

Hyperlinks in PivotTables and PivotCharts would make them much more powerful. Hyperlinks could go in the values, headers, axis categories, legend items, etc. That is, hyperlinks should work with both calculated columns and measures.

Examples of uses of hyperlinks in PivotTables and PivotCharts:

• Calculated column example: Add a hyperlink to each site of an organization. The hyperlink could lead to a web page about that particular site or a folder containing files for that site.

• Measure example: In a PivotTable, track the existence of translated versions of web pages, courses, etc.
Row headers: web page
Column headers: language
Values: a ✓ that links to that particular web page if it exists.

I'm sure that you can think of better examples. Leave them in the comments!