Hellow guys, Welcome to my website, and you are watching Power bi tricky interview questions | CALCULATE Dax made Easy. and this vIdeo is uploaded by PowerBI Zone at 2024-07-18T07:30:07-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Power bi tricky interview questions | CALCULATE Dax made Easy |
| Video Uploader | Video From PowerBI Zone |
| Upload Date | This Video Uploaded At 18-07-2024 14:30:07 |
| Video Discription | Hello Friends ,in todays episode we see a very interesting and tricky Question asked in E&Y and it involves the usage of the DAX Function called "CALCULATE".We have tried our level best in explaining the scenario and then explaining the CALCULATE function in the easiest way possible. Hope you like the step by step explanation . Consider the below measure written in DAX and has the usage of the CALCULATE function : Measure = CALCULATE( CALCULATE(VALUES(Color[Color]),Color[Color]="Black"), Color[Color]="White") the interviewer may ask what will be the output and the answer is Black .Since How the calculate function works is : Step 1: it uses the outside CALCULATE first and then filters the result for FILTER ="White".This gets overridden in step 2: Step 2:the inner CALCULATE gets evaluated and the previous value of White gets overridden bhy Black. π₯π₯π₯Check out our other Power BI Tutorials Videos :π₯π₯π₯ π1.SamePeriodLastYear with Example: https://www.youtube.com/watch?v=WU9pJyyCOJE π2.How to Calculate Running Totals: https://www.youtube.com/watch?v=1o9E7NV1uP4 π3.Duplicate Vs Reference : https://youtu.be/n7XzkVH3Ij0 π4.Merge Vs Append: https://youtu.be/ZfmdKRq2A4Y π5.Calculate Function in DAX Power BI: https://youtu.be/mPhpG8VYDlI π6.Filter Function in Power BI: https://youtu.be/5wKvfL6rfmY π7.Row Vs Filter Context: https://youtu.be/AKyijOTkMnw π8.ALL DAX Function: https://youtu.be/co8s79zVS7E π9.ALL Vs ALLSELECTED : https://youtu.be/bv7Yho9DX0c π10.ALL Vs ALLSELECTED VS ALLEXCEPT : https://youtu.be/aVVua4fG1V0 π11.ALL Vs REMOVEFILTERS : https://youtu.be/BPo7SzJXb0w π12.TOPN Dax Usage : https://youtu.be/UEjgu5d607Q π13.Summarize Dax Function in Power BI: https://youtu.be/4W4eENnFi24 π14.Summarize Vs Summarizecolumn :https://youtu.be/ugVyoTwReag π15.Calendar Vs CalendarAuto : https://www.youtube.com/watch?v=pIIk42R4ex4 π16.How to create a date table in Power BI : https://youtu.be/H8BVh6s6egU π17.How to calculate Running total for date values in Power BI https://youtu.be/NBGGHdKxupk π18.How to default your slicer to current year/Month (Method 1 using custom visual) : https://youtu.be/o-gr3XgU1mg π18.How to calculate running total in power bi for non date values: https://youtu.be/85sKPSnc_GE π19.Usage of datediff in Power BI: https://youtu.be/nhvbGRAk2tk π20.Isblank() Vs Isempty : https://youtu.be/OItCmUrklhk π21.Power BI Scenario based Qn A :https://youtu.be/vkdNS3hEBiA π22.Power BI Interview Question (SWITCH function in FORMAT): https://youtu.be/9G3zebtJZ4k π23.Substitute dax to get rid of Numbers from Alphanumeric column: https://youtu.be/zhMMJyb3WoQ π24.Substitute dax to derive Numbers from Alphanumeric column: https://youtu.be/5l2jM7ZISaA π25.Power bi scenario based interview QnA - Using PATHITEM & SUBSTITUTE DAX: https://youtu.be/L7ugQbmDGh4 π₯π₯Learn Power BI through our vlog and Free Videos:π₯π₯ https://powerbizone.com/category/articles/ β€οΈβ€οΈDo not forget to Like ,Subscribe and comment which keeps me motivated !π₯π₯ Mail your Queries at : yourpowerbizone@gmail.com Download the pbix from : https://drive.google.com/file/d/1GJnYx7lFtZsMlAPZksO05UF2Wj8bUxAx/view?usp=sharing |
| Category | Education |
| Tags | power bi tricky interview questions | power bi calculate | power bi interview questions | power bi calculate dax questions and answers | power bi interview questions and answers | power bi calc | leila gharani | power bi zone | power bi how calculate dax works | flow of calculate dax in power bi | power bi | power bi interview questions for freshers |
