How to apply GROUPBY function using power bi DAX

Recipe Objective - How to apply GROUPBY function using Power BI DAX?

Task - Create a new table that contains total sales done by each Category using the superstore dataset.

Hands-On Guide to the Art of Tuning Locality Sensitive Hashing in Python

Step 1 - Open Power BI report

Step 2 - New table

Go to Data pane -> Go to Table tools -> New table

Step 3 - Dax query(GROUPBY function)

SYNTAX - GROUPBY (table, [groupBy_columnName , [groupBy_columnName, […]]] , [name, expression, [name, expression, […]]])

Write down the formula as new_table = GROUPBY(Superstore,Superstore[Category],"Total sales",SUMX(CURRENTGROUP(),[Sales]))

This will create a new table that contains total sales done by each Category.

In this way, we can apply GROUPBY function using Power BI DAX.