Forum Discussion

Kisi3ll's avatar
Kisi3ll
Frequent Visitor
8 years ago
Solved

sales summary

Hi everyone,   My imported querry looks like that: project name               sales in 2017                sales in 2018                sales in 2019 project A                        1           ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi Kisi3ll,

     

    In your scenario, you can open the Query Editor, rename the column "sales in 2017",  "sales in 2018", "sales in 2019" to "2017","2018","2019". Then select the columns "2017","2018" and "2019" and click Unpivot Columns. Use Group By to return summarized table. For more information, you can download attached pbix file to have a look. 

     

     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi Kisi3ll,

 

In your scenario, you can open the Query Editor, rename the column "sales in 2017",  "sales in 2018", "sales in 2019" to "2017","2018","2019". Then select the columns "2017","2018" and "2019" and click Unpivot Columns. Use Group By to return summarized table. For more information, you can download attached pbix file to have a look. 

 

 

Best Regards,
Qiuyun Yu