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
138 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,490 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

0 votes
1 answer

How to create summary table based on selected filters/slicers?

Here are the steps you can follow: 1. ...READ MORE

answered Nov 12 in Power BI by anonymous
• 48,800 points
155 views
+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,410 points
8,949 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,970 points
279 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,450 points
1,204 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,620 points
1,761 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,020 points
441 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,720 points
647 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,300 points
1,719 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,950 points
186 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,490 points
10,550 views