Top 10 Power BI DAX Functions | Asked in Interviews 2024

I literally went through more than 217 powerb Dax functions and found out that these are the top 10 powerbi Dax functions in my past videos I have talked about powerbi I have talked about powerbi Dax functions and there are many many videos about power Bay on my Channel all the links will be in the description in case this topic is new to you please go through that video to understand more about powerb understand more about ax functions and jump into this video so in this video we shall be focusing on the top 10 powerbi Dax functions that you need to focus before going for your next interview see you in the [Music] video before getting into this video just a disclaimer that I'm not going to explain each and every Dax function that I'm going to tell as part of this video I'm just going to name the Dax functions in case you want to learn how these Dax functions work please check out the links in the description where everything is explained in a very Crystal way in case you still have any doubts you can always reach out to me on LinkedIn or in the comment section I keep an eye on each and every comment so let's get into this video most important Dax function is going to be Basics now most of you might be thinking basic functions are you serious yes basic functions are also very very important I know most of you already know about sum average minimum maximum all these Dax functions but these are needed because interviews always ask easy questions and then they increase the difficulty level based on what you know and how you are answering they they will directly not be able to ask you some difficult questions so they always start from the basic so Basics are very very needed the second most important is going to be calculate now calculate is a very very important Dax functions because because it's a very commonly used Tax function you want to create the total salary of males you use calculate you need to create the total salary of females you can use calculate you need to find the average age in a particular location you will definitely need calculate so calculate command is very very important how to use it check out the link in the description the third important Dax function is going to be filter now filter acts as a filter if you are aware of SQL where we use the wear Clause select star from table name where age is greater than 50 that means you're filtering out all those candidates whose age is more than 50 exactly same we also do in powerbi using the filter command you can always call calculate without filter by default if you call calculate and then sum of something comma and then you give gender equals to equals to male that also Al acts as a filter explicitly also you can pass the filter function the fourth most important is going to be count and count rows now everybody knows count and counters are very very basic functions but they are also required the fifth most important Dax function is going to be related now related and related table these are the two Dax functions that you need to master you need to know because sometimes you might work on two different tables who are you know not having some Rel relationships in power ba so related function basically is used to return a related value from another table the next important Dax function is going to be switch now what is switch switch is very common we have been using switch functions in programming and switch is also there in powerbi switch basically means switch cases that means if you are implementing a case like this if this then do this else if do this else if do this that if else blocks can be replicated and can be created a switch case switch cases are those kind of functions which are used to evaluate an expression against a list of values and return one of multiple possible result Expressions the next important thing is going to be X functions now X functions are wide there are multiple X functions sum X average X Min x max X well if you know one of them you will potentially understand the value of it so what is the difference between sum and sum X please go through the video in the description everything has been explained in a very proper way and then you will once you go through them once you practice them you will definitely be able to answer that in the interviews and this is one of the most important questions even I ask this one of my most important question is X functions and time intelligence functions because these are the two areas where I try to see whether the the candidate has knowledge or not the next most important Dax function the eighth one is going to be time intelligence function well I could have separated the different time intelligence functions like total y to be a separate function total MTD to be a separate but I just wanted to combine it so the number eight will be time intelligence functions where you should focus on total YTD total qtd and total MTD very very important function functions now usage and all everything is already there in the videos I'm not going to discuss each and every Dax function in this video we will be focusing more on the top 10 ones in case you think that there are some top 10 there are some important functions that I have missed in this video you feel that they are important let me know in the comment section and I will tell you whether they're actually important or not whether they are being asked in in interviews or not number nine if else blocks if else blocks are very basic concepts let's say you want to create a derived Matrix let's say you have a column like age you want to create age bins obviously you can use conditional formatting and then create a new column which is fine using power query editor but you can also create age bins using IF Els blocks how to study that is already there in the description last and not the least we have top end function which is also a very very important function so these are the top 10 uh Dax functions that I feel you should learn at least these now there are a bunch of like more than 200 220 Dax functions available in the market right now available inside powerbi uh exactly how many are there it's unknown but there are more than 200 for sure I have also built a simple PDF document considering some of the important Dax functions that I will also leave as part of this video please go ahead and watch out that PDF document as well now in this video we already discussed about the top 10 but if you see there are more than 253 that I have already told you that these are important like basic functions some average main Max these are already four count count row six uh calculate filter eight then in time intelligence total YTD MTD qtd 11 so we I have already told you more than 25 or 30 Dax functions that are most important please please go through these Dax functions before your next powerbi or data analytics interview in case you like this video please like share and subscribe the channel that's all about this next video is going to be a project video stay tuned see

Channel: Satyajit Pattnaik

Views: 9,315

Keywords: satyajit pattnaik, data science, data analytics, machine learning, data analyst, artificial intelligence, Projects, I tried 217 Power BI DAX functions, 217 dax functions, top 10 dax power bi, top 10 power bi dax functions, top 10 DAX functions power bi interview, power bi dax, power bi dax functions, learn dax, dax power bi, satyajit dax, satyajit power bi, satyajit data analytics, satyajit data science, top 10 DAX functions, totalytd vs datesytd in power bi, calculate dax

Id: QaFiUbVeHTA

Length: 7min 54sec (474 seconds)

Published: Thu Feb 01 2024