 Hey guys, welcome to SSULitech society side, and this is continuation of Power BI tutorial So here as we are going to discuss about the M language and data analysis expression that is DAX So basically in the power BI we can use two languages. First is the M language and second is the DAX language So where we can use these? Let's go to on Power BI desktop and we'll see in the practical so here I'm in the Power BI desktop if we'll go on the transform data in the query editor So inside the query editor, what language we can use? Here we can use the M language. So how we can see? So here go to on the dim address table and here as we can see the address line one So what is our requirement? We want to add a one more column and on that column We just want to fit first five character from this address line one So how we can do that? Go to on the add column and here we can use the custom column So we have already discussed about this. So directly go here and Let's call that as first five character and Here we need to specify the M language. So in the M language, we will use the text dot start So it will be act as left in the DAX or any another language like in SQL Server in Excel So now we can start the bracket after that here. We need to specify the column name So that is address one. So address line one comma then how many characters we want? We want five character. Now we can Close the bracket after that we can click on okay So it will add one more column and it is having first five character from the address line one So this is the M language by which we have created this column Now go to on the power way desktop after loading this and where we can use the DAX formula By which we can get first five character from the address line one So if we are in the power way desktop not in the query editor Then our DAX formula will be help us and if we'll have inside the query editor Then our M language formulas will help us to Manipulate our existing data So here we need to wait few seconds until it will not be loaded Now it is loaded here. I want to add one more page and here We can add the table. So don't worry about this. We'll see in the upcoming videos about the variations So make it bigger now go to on the address table and in the address table We have the address ID address line one. So we can drag and drop this address line one and here We can see the first five characters column. So we can drag this and drop it here So here we can see it is having first five characters so We made this in the end language now go to on the DAX and we'll try to create one more column So here we can see the data. So what on the data view and Here go to on the dim address. So we need to select that table and Here we can see the address line one. So we need to create one more column in the Power way desktop and that will have first five character. So here we can see add column option So we can click on that After that if we'll add one more column So this is our newly created column and here we can call this as DAX first five character in the DAX It is very similar as we have formulas in the Excel or in the SQL server So we can directly use the left after that we can start the bracket Then we can see the address line one So this is address line one we can select that one then comma then five then close the bracket And here we can see the commit so we can click on the commit So new column will be added and that will have only five characters from the starting so go to on the Report view and here we can see we have this DAX first five character So drag it and drop in the values So here we can see we are having the same data as we seen in the query detail same in the DAX formula So it's up to you either you can use the M language or you can use the DAX formula for creating such type of things and I will also create a separate playlist for the DAX formulas. So where you will learn about the DAX formula in details So don't worry for that will create a separate list for that And we'll try to add few important formulas in the M language on that playlist So guys as I have told you we have a single Power BI and inside we can use two languages. First is M language second is DAX So guys, I hope you have understand where we can use the M language and where we can use the DAX So thank you so much guys 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 guys