 Hey guys, welcome to SSULitech. So, see this side and this is continuation of Power BI tutorial. So, in the last video, we have seen how we can play with the merge queries, where we seen about the left outer join, then the right outer join, full outer join. After that, we seen the inner join and we also seen how we can play with the anti-left and anti-right join. So, it's time to index columns. So, what is the index column and how we can use it in the Power BI desktop in query editor. So, go to Power BI desktop and we will see in the practical. So, let's get started. So, this is our project and this is our table which we have created manually, like first is country name and second is sort name. So, today what we want to do? So, today we just want to create the index column on this table to identify the unique values in numbers. Here, as we can see the country names or in the sort name is the unique values, but we want to create a unique number that will be started from 0, 1 or any custom values which we want. So, how we can do that? So, for that we can move to add columns. We have seen the home ribbon and we have seen the transform remain. After that, it's time to play with the add columns. So, in the add column, we can see here column from example, custom columns, invoke custom function, after that conditional columns, after that index columns, then duplicate column. So, today we are going to discuss about index column. So, once we click on index column, here we can see we have from 0, from 1 and custom. So, first let me try with the 0. So, it will be going to start from 0 and increase 1 by 1, so 0, 1, 2, 3, 4, 5. So, this is about the index column starting from 0. So, just roll back this and this time check for 1. So, the starting value should be 1. So, here we can see it's going to start from 1 and increment 1 by 1. So, just roll back it and now let's have a look of custom. So, what is the custom? So, here it's going to ask the starting index. Let me start with 10 and increment, we want to increment by 10. So, it will start from 1, second value 20, then 30, then 40. Click on OK. Here we can see 10, 30, 30, 40, 50 and 60. So, this is about the index columns. So, what I want? I want to start from 1 and this is the index column and put this in left side and call this as ID. So, it's going to uniquely identify each row. This is all about the index columns. So, I hope you have understood how we can use the index column in our project. 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.