 Hey guys, welcome back. So, see you in this side. And this is continuation of Power BI tutorial. So, as we have discussed in the last video, we have created the DIM address table. It's time to create the DIM item and DIM customer table. So, how we can create this? Go to on Power BI Desktop. And here, as I told you we can create the reference or we can create the duplicate. So, I am very happy to use the reference. So, this time, this is for the customer. so let me rename this with the dim customer so this is a dim and customer now here we just want to get only those columns which are the customer related so we need to remove other columns so go to on choose column and here we can see this is customer id then the account number and then build to address for those customers so these three columns will go inside the customer table so we can click on okay that looks good after that we need to remove the duplicate values so we can go to on this remove rows and here we can remove the duplicate so now we have created the dim customer table next we need to create the dim item table so how we can create the dim item table go to our main table and right click on this and create a reference and this time let me call this as dim product now we just want only two columns first is product id or product number second is product name so go to on choose column again and we are expecting only two columns so here this is our product name and product number now click on okay it looks good now we need to remove the duplicate rows so we can remove it it will take few seconds now it's done after that the product name should be the left column so we can drag and drop and rearrange the order of the columns so now it looks good in the dim customer customer id then the account number then the build to address it is also good then dim address table so finally we have created the address table and we have created the item table and we have also created the customer table so now there is no need to create this uh date dim date table over here because in the power vi we are having an option directly to get the date year quarter month and day so there is no need to create this dim date table 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