 Hey guys, welcome to SSUnitak, so soon this side and this is continuation of Power BI tutorial. So, today we are going to finish the sales fact table. So, we have made a great progress in our project and we have created the dim tables and we have also discussed about the star schema. In star schema as you can see we have created this dim address table, then dim item table, dim customer table. We have split this data into all these dim tables, now it's time to create this fact table. So, how we can create this fact table in real time. So, go to all Power BI desktop and we will see in the practical. So, let's get started. So, this is our project and this is our file. So, just I want to create a replicate of this. So, right click on this and here we can create the reference. And here we can call this as final. So, we need to play on this first thing just concentrate on the address. So, in address we are having all these columns but the joining column is address ID. So, these columns should be removed from this fact table and it will have only one column that is address ID. So, how we can do this here go to on last and here just remove all these. We can go to on home ribbon and here we can remove the columns. So, this column is removed. So, we can join between the address by using this address ID. Second thing, we need to go on this item and we will concentrate on the item. So, in the item as we can see we are having the product ID. So, a rest of two columns that is product name and product number should be removed because in the dim product we are having the product name and product number. So, we can join between the dim product and our final fact table by using this product ID. So, go to on final country sales and here we can see we are having two columns that is the product name and product number. So, these two columns will be removed. So, just select these two columns and click on this remove columns. So, now we are having the product ID we can join between this table with the dim product table. Now, we are having this last that is dim customer. So, in the dim customer we can see we are having customer ID and account number and bill to address. So, we need to get only customer ID. We don't want to get account number and bill to address in the fact table. So, here so this is the customer ID and this is the account number. So, we need to remove this column first after that bill to address. So, remove this column as well. So, now we are having this final fact table. So, thank you so much for watching this video. If you like this video please subscribe our 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.