 Hello, welcome to assist unit at social this slide and this is continuation of Power BI tutorial. So, in this video, we are going to see how we can replace the existing values with the new values. After that, we will also see how we can format the columns with their data types. So, in the last few videos, we have seen how we can edit the columns and rows and how we can append the queries. So, in this video, we will see replace the existing value with the new one and formatting the columns. So, let's get started move to probably desktop and this is the query editor. So, here as we can see in the last column that is country name, it is having Australia and here we can see AUS that is also for Australia. So, in few places, we are having AUS and few places we are having complete name with the Australia. So, we just want to replace this AUS with the Australia. So, for that, we can select that cell which we want to replace like here we are having multiple values but we can select any one of them then move to transform ribbon after that here we can see we are having replace values. So, just click on this here we just want to replace AUS which is value to find and replace with the Australia with the full name. So, we can see Australia. Now, let me click on OK. Once we click on OK, then this AUS will be replaced but this Australia which is also having AUS it will be replaced by Australia. So, click on OK and we will see. So, here we can see this is replaced correctly but it is having the problem. So, how we can replace only AUS which is having in the entire cell. So, we can roll back this and again select that value click on replace and here let me write the Australia in the replace with the full after that here we have advance options. In the advance option, we are having match entire cell content. So, we can select this checkbox and click on OK. This time it will replace only AUS with the Australia. So, now it looks good. Next, we just want to change the data type of the columns. So, as we can see for cell order ID, here cell order ID is having text column as we can see from here. So, if we want to change their data type from text to number. So, we have several options in Power BI. So, by using that options we can replace the existing data type with the new one. So, first we can click on this and here we can select the whole number. So, here we can see change type is added in the applied steps and this value is integer right now. So, this is the first option just roll back this and go to on home tab and here we can see data type that is text. So, we can replace this with the whole number. So, it is also doing the same as we did before. So, this is the second option roll back and see the third option. Here we can move to transform ribbon and here we have data type as text. So, we can also use whole number. So, it will be going to perform the same as we did in the before. So, just roll back this. So, these three options are available by which we can replace the existing data type with the new one. Here we are having a lot of columns. We don't want to replace the existing data type with the new actual data types one by one. We just want to do in a single click. So, how we can do this? We have an option in the Power BI. So, just select all the columns after that here in the transform ribbon we can see we are having detect data type. So, once we click on this detect data type then data type of these columns will be automatically detected and replaced by new data types. So, click on this and we will see. So, for sales order ID it is whole number that is good. In the order date this is date due date date and this is alpha numeric value. So, that the text good customer ID integer account number is text after that build to address is integer and these two is numeric values then we can see all these is detected automatically and replace with the new data types which is suitable for that column. So, I hope you have understand how we can replace the values and second we have also understand how we can change the data type of any column. 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.