• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Resources
    • DAX Glossary
    • Download Center
    • Template Apps
    • Data Stories Gallery
    • Solution Gallery
    • Learning Resources
  • Courses
    • Introduction to Power BI – FREE Online course
    • Power Query Online Training for Power BI
    • M Language Online Course: The unofficial and Practical Reference Guide
  • Blog
  • Shop
    • Courses
    • Swag
    • Template Apps
    • Donations
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / SUMMARIZE

SUMMARIZE

posted on August 17, 2017

« Back to Glossary Index

Syntax

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

Tutorial with example

Learn how to use the function SUMMARIZE in DAX/ Powerpivot.

The function SUMMARIZE can return a summary of sales grouped around the calendar year and the product category name, this result table allows you to do analysis over the re-seller sales by year and product category.

Northwind data source: https://www.youtube.com/watch?v=k3NMI…
Icons: https://www.iconfinder.com/

Download example file:

Link to Power BI file here.

Remarks

  1. Each column for which you define a name must have a corresponding expression; otherwise, an error is returned. The first argument, name, defines the name of the column in the results. The second argument, expression, defines the calculation performed to obtain the value for each row in that column.
  2. groupBy_columnName must be either in table or in a related table to table.
  3. Each name must be enclosed in double quotation marks.
  4. The function groups a selected set of rows into a set of summary rows by the values of one or more groupBy_columnName columns. One row is returned for each group.

 

Was this helpful?
[Total: 10   Average: 4.5/5]
Related Articles:
  • DAX Fridays! by Curbal
See Also:
  • ADDCOLUMNS
  • CURRENTGROUP
  • GROUPBY
  • ISSUBTOTAL
  • ROLLUP
« Back to Index

Reader Interactions

Comments

  1. Christopher Hastings

    August 23, 2018 at 9:08 pm

    Thank you so much for your great videos!

    Reply
    • Ruth Pozuelo Martinez

      August 28, 2018 at 12:01 pm

      My pleasure! 🙂
      /Ruth

      Reply

Let us know your thoughts... Cancel reply

Footer CTA

Join our community of +20,000 professionals

Become a Member

Subscribe to YouTube

About us

Curbal AB
Kopparbergsvägen, 10
722 13 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2021 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In