Summary Table

0 votes
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 in Power BI by vnk
47 views

1 answer to this question.

0 votes

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 by Cherukuri
• 31,840 points
Thanks for the information.

Related Questions In Power BI

0 votes
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
• 16,630 points
2,912 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
• 42,510 points
107 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,310 points
308 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,550 points
713 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 in Power BI by Phalguni
• 1,010 points
123 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 in Power BI by Avantika
• 1,500 points

edited May 17 by Omkar 97 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,690 points
145 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
794 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 in Big Data Hadoop by nitinrawat895
• 10,730 points
119 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 in Power BI by Cherukuri
• 31,840 points
286 views