Forum Discussion
Appended queries optimization
Dear Greg. Thank you for response.
I have 12 separate queries (12 excel uploads). I have appended them and get 1 one Yearly sales table with 12 amount columns. Then I have created new 'Grand Total' column and add up all these 12 monthes sales. Now I want to pivot my results related to this new 'Grand Total' column. Your solutions is good, but it works for native query columns. The columns which are added out of query editor will not be found in query ediyor window.
Perhaps this DAX Unpivot Quick Measure:
https://community.powerbi.com/t5/Quick-Measures-Gallery/DAX-Unpivot/m-p/574832
If not, please provide very simple sample/example data and expected result. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Since my queries contain huge amount of data I try to create sample of the data in the excel.
I wonder, if merge function will be solution for me?
If you append with the names being the same this should be the result:
From here you can easily show total amount per customer or product.Your are right tex628.
This is exactly what I have now. But I want to see 31+10+19=60 for 202 Customer.
If product id and customer id are the same I would like to sum the amount.
