 Hey guys, welcome to SSUnitech, so till this side and this is continuation of Power BI Tutorial. So today we are going to see what is the group by in the Power BI. So this is very similar as we are having in the SQL Server or any other database tools like Oracle and IBM DB2. So what group by does? So basically it is going to grouping on one or more than one columns and the major columns that is the numeric or integer columns will be aggregated based on those grouping columns. So this is the group by as we are having in the SQL Server. Let's move to Power BI where we will see how we can use the group by. So this is our project as we are currently working on. So here basically we just want to grouping on the basis of product names and their countries. So other columns should be removed as I told you here we can use choose column options. So go to one choose column and here we just want to only few columns like product name and we are wanting this country name after that we just want to this order quantity. Now click on OK. So it will have only these three columns. So what our requirement is? So we just want to give the total order quantity for each country and their products. So we just want to apply the group by on this country name and product name and we just want to aggregate this order quantity with the total order quantity. So how we can do this? So here go to one transform ribbon and here we have group by so we can click on this group by. So basic it is going to use this order quantity. We don't want to use this use country name and in the advance we can add one more column. So this is product name. Now here we want to specify the new aggregate columns. It should be total quantity. So this is true quantity and what operation we want. So we just want to use the sum and here we need to specify that column. That column will be part of the measure. So that is order quantity. Now we can click on OK. So here as we can see we are having countries France and this is a product name and order quantity is 2. In the Australia product name is mountain 100 silver 44 order quantity is 27. So this is the very similar as we are having in SQL Server or any other database tools. So thank you so much for watching this video. If you like this video please subscribe my channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much.