Forum Discussion
Transpose table with weighted averages
Greetings all, I am having a real challenge trying to replicate a procedure I used to do within pivot tables in Excel. The data I am looking at are millions of customer invoices, and I'm inte...
To add to this, I appreciate that I can get the aggregated, customer level data in the report by adding a table and the weighted averages calculated in the new measures added. However, I then need to use the customer-level data for further manipulations, and therefore it is insufficient as a report output, I need to export it back as an additional query if possible.
:-)
Thanks again everybody. Viva Power BI!