RE: How to show the aggregate of column values in a separate row

[smpa01]

Hi,

I have the following Table.

I want tio achieve this in Power Query/Power BI.

If someone can please help, would be great.

Thank you in advance.

[Greg_Deckler]

Just import the table into Power BI Desktop and use a table visualization to display it. Table visuals automatically include a total row.

[smpa01]

Thanks for your suggestion. I should havve mentioned this prior to posting this problem. I have already tried this and I can see a row called TOTAL for the columns with numerical values being generated by Power BI desktop Visualizations when the data is organised in a Table Visualization. However, when I export the same table, it gets exported in CSV and same TOTAL row is omitted altogether.So I tried exporting the same CSV into a Power Query to find a solution. But I couldn't.

I aim to generate a report which will contain the aggregate of some of the columns that I want with numerical values.

Is there a way to solve this.

[Greg_Deckler]

To be clear, when you say "generate a report" you are referring to generating a CSV file, correct?

[smpa01]

When I say generate a report I do mean generating a CSV file which will containg the desired aggregate I want. Since it did not, I tried to the same task with Power Query where my source file was that CSV file exported from Power BI desktop.

[v-yuezhe-msft · Accepted solution]

Hi @smpa01，

In Power Query, you can use one of the following methods to display the total row.

a. Select data range in Power Query, right click data range, choose Table->Totals Row.

b. Select data range in Power Query, right click data range, choose “Quick Analysis”, then “Totals” and select your desired aggregation  function.

Thanks,
Lydia Zhang