Forum Discussion
Post PatronAnalyze in Excel
Community Championpstanek yep that is right, you can't put all fields in Values in pivot table as you can do in power bi. You will need to create specific measures in power bi to be able to drop those into Values in pivot table.
pstanekI can put no one:smileyvery-happy: only measures works.
When you say specific, you exactly what.
When I want to sum costs, I have to create measure sum(costs).
Or do you mean something else?
v-qiuyu-msftCommunity Support
Hi pstanek,
I agree with ankitpatira, what you get is expected. If you want to put those numeric fields in Power Pivot table ∑VALUES area, you need to create a measure to aggregate( sum, count, avg,...) those fields in Power BI firstly. For example, the numeric field is [SalesAmount], create a measure called TotalSalesAmount, TotalSalesAmount = Sum(Sales[SalesAmount]). Please refer to this article to create a measure: Tutorial: Create your own measures in Power BI Desktop.
When you open the .odc file which created from "Analyze in Excel", you will find the TotalSalesAmount measure under the ∑ pane in PivotTable fields. You can put it in the ∑VALUES area.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu- pstanek
Do you know If ti can work for dashboard. I have colleague with limited access to database. he can see only values and tables, that I share with through dashboard ( in filters, tables).
I do not want him to see all of our database, but only these things He is able to use it at work.