Summary Table

+1 vote
Hi

In Power BI, How to  Create summary tables- reduce the size of data to the power bi.

As per requirement and give me any suggetion on summary tables and explain with example.
Sep 4, 2019 in Power BI by vnk
89 views

1 answer to this question.

+1 vote

Hi, @Vnk

Summary tables can be formed by aggregating or grouping the actual data tables.

To do so, Use summarize( ) function.

Summarize( ) returns a summary table for the requested totals over a set of groups.

Syntax:   SUMMARIZE(<table>, <groupBy_columnName>[, <groupBy_columnName>]…[, <name>, <expression>]…)

Ex: 

SUMMARIZE(ResellerSales_USD , DateTime[CalendarYear] , ProductCategory[ProductCategoryName] , "Sales Amount (USD)", SUM(ResellerSales_USD[SalesAmount_USD]) , "Discount Amount (USD)", SUM(ResellerSales_USD[DiscountAmount]) )

In the above example, ResellerSales_USD is the table name, which is grouped by fields DateTime[CalendarYear]ProductCategory[ProductCategoryName]. The table then returns a summary table by calculating SUM(ResellerSales_USD[SalesAmount_USD]) and renames column as Sales Amount (USD) and SUM(ResellerSales_USD[DiscountAmount]) as Discount Amount (USD) along with the grouped columns.

The final table structure would be like below.

DateTime[CalendarYear]    ProductCategory[ProductCategoryName]   Sales Amount (USD)  Discount Amount (USD)

Hope it helps.

The example and documentation can be found here.

answered Sep 4, 2019 by Cherukuri
• 32,440 points
Thanks for the information.
Hey @Vnk, please do upvote @cherukuri's answer if it has helped you. Sign in to Edureka community and get points by contributing (asking, answering and commenting).

Related Questions In Power BI

+1 vote
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,030 points
4,616 views
0 votes
1 answer

Power Bi Dax Table

You need to wrap the numbers in ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 51,830 points
173 views
0 votes
1 answer

Select Columns from table instead of removing afterwards in Power Query

Try this. let db = Sql.Databases("sqlserver.database.url"){[Name="DatabaseName"]}[Data], Sales_vDimCustomer = ...READ MORE

answered Oct 31, 2018 in Power BI by Shubham
• 13,380 points
529 views
0 votes
1 answer

Pivot table drill down functionality in Power BI

There is a clear deficit in the ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,590 points
1,136 views
0 votes
1 answer

How do you add a slicer from different table in Power BI?

In order to add a slicer from ...READ MORE

answered Mar 5, 2019 in Power BI by Phalguni
• 1,010 points
209 views
0 votes
1 answer

How to sum a data table in Power BI?

It's a good practice if you avoid ...READ MORE

answered May 17, 2019 in Power BI by Avantika
• 1,500 points

edited May 17, 2019 by Omkar 716 views
0 votes
1 answer

Types of tables in MySQL

MyISAM is the default table that is ...READ MORE

answered Aug 21, 2018 in Database by CodingByHeart77
• 3,710 points
274 views
0 votes
1 answer

What is the difference between Hive internal tables and external tables?

Hive has a relational database on the ...READ MORE

answered Nov 19, 2018 in Big Data Hadoop by Neha
• 6,280 points
1,132 views
0 votes
1 answer

Differentiate between Hive internal tables an external tables.

Hive comprises of an RDBMS(Relational-Database-Management-Systems) on its ...READ MORE

answered Mar 27, 2019 in Big Data Hadoop by nitinrawat895
• 10,870 points
137 views
0 votes
1 answer

How to create final table based on Joins of two tables in power BI?

Hi Nithin, It is easy and simple. 1. Go ...READ MORE

answered Mar 1, 2019 in Power BI by Cherukuri
• 32,440 points
1,716 views