Question

What is the common table function used for grouping data in PowerBI?

Answer 1

1. SUMMARIZE () is the main group by function in SSAS. It summarizes a large number of rows into a table with the provided criteria column.
2. SUMMARIZECOLUMNS: These are the new group functions used for SSAS and Power BI Desktop. These functions are more efficient and are specified by columns, tables, groups, and expressions.