Forum Discussion
Exporting data table with subtotal and total
May I know if I can export the table with subtotals and the total from PBI?
I learnt it can be done by analyzer in excel, but could spend less time if it could be directly shown when I export the data out with subtotals and totals.
Thank you!
2 Replies
lchmoo_ No, I don't believe Export will do that, only Analyze in Excel.
lchmoo_ , I don't think downloaded. but there is an option
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
https://docs.microsoft.com/en-us/power-bi/collaborate-share/desktop-troubleshooting-analyze-in-excel
Also refer on in May 2020
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/#_Excel
