Forum Discussion

jdunmall's avatar
jdunmall
Icon for Advocate I rankAdvocate I
10 years ago

Analyze in Excel: aggregation of numeric fields

I'm having trouble understanding how to use the new Analyze in Excel feature. The documentation says:   Excel PivotTables do not support drag-and-drop aggregation of numeric fields. Your dataset i...
bhanuregonda's avatar
bhanuregonda
Regular Visitor
8 years ago

Hi,

 

I have a powerbi report in which I have YTD calculated measure and i am getting the correct result in power BI for the %YTD value out of it, but when I am analyzing that report in Excel - i am not getting the same values as in Power bi in that column. Not sure why is it different from power bi to analyze excel.

 

Please help me with this.

 

Thanks