on 14 Jun 2016 00:18:58
The Analyze in Excel feature is an excellent addition to Power BI. For an enhancement, I recommend adding the ability to utilize Excel's standard pivot table functionality of adding implicit measures for numeric fields from source data. This functionality would be similar to the process for creating pivot tables with Power Pivot where custom measures can be used with standard Excel measures in the same pivot table.
The requirement to create custom measures for simple aggregations (i.e. sum of xx numeric field) removes one of the largest advantages of creating summarizations in Excel. It is also difficult for report developers to anticipate all potential aggregations the end user will want to review. Consistent pivot table functionality in Excel is important for this feature since the target audience for results are Excel users.
- Comments (6)
RE: Analyze in Excel Standard Pivot Table Aggregations
Is there any update or workaround for this? Doesn't make sence for me to create from all fields a measure to be able to report in excel. I don't understand why you can add fields as a measure while in excel it doesn't allow you...
RE: Analyze in Excel Standard Pivot Table Aggregations
This idea has been planning for a long time, is there any update on this?
RE: Analyze in Excel Standard Pivot Table Aggregations
I too agree that adding explicit measures even from Excel (you already can do this from Power BI Desktop) is a good feature.
Since standard implicit measures like count and average doesn't work from Excel, using the Analyze in Excel feature is almost useless if the data set is not prepared for this
RE: Analyze in Excel Standard Pivot Table Aggregations
It would also be good if we could define our own EXPLICIT measures, on the fly, using DAX, in an Excel workbook using Analyze in Excel. (Like you can in an Excel workbook that has its own Power Pivot data model.)
RE: Analyze in Excel Standard Pivot Table Aggregations
I believe PBI Connect to Data and Analyze in excel need this. I posted a related idea in Excel as well.
https://officespdev.uservoice.com/forums/224641-feature-requests-and-feedback/suggestions/32970352-pivot-tables-should-support-dataset-measures-from
RE: Analyze in Excel Standard Pivot Table Aggregations
This is related to: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10435572-create-dax-measures-fields-and-tables-in-direct-q
If either this idea or the other is complete using Analyze from Excel on Live data would be a huge feature.