Power BI Scenario based Interview Questions : Optimize Sales in DAX using Summarize & Filter
Вставка
- Опубліковано 12 вер 2024
- In this video we take a look at the recent Power BI interview question asked in PWC.The question was to optimize the table in such a way that the table be filtered only for "France " values.
Answer to this question is explained in details in this video.We use FILTER inside SUMMARIZE functionin dax to get the optimized version.
#powerbi #powerbi_training #powerbipro #powerbizone
🔥🔥🔥Check out our other Power BI Tutorials Videos :🔥🔥🔥
👉1.SamePeriodLastYear with Example: • difference between par...
👉2.How to Calculate Running Totals: • How to calculate runni...
👉3.Duplicate Vs Reference : • power bi difference be...
👉4.Merge Vs Append: • power bi difference be...
👉5.Calculate Function in DAX Power BI: • What is Calculate Func...
👉6.Filter Function in Power BI: • Filter Function in Pow...
👉7.Row Vs Filter Context: • Row Context Vs Filter ...
👉8.ALL DAX Function: • How to use ALL Dax Fun...
👉9.ALL Vs ALLSELECTED : • allselected dax|all vs...
👉10.ALL Vs ALLSELECTED VS ALLEXCEPT : • All Vs AllSelected Vs ...
👉11.ALL Vs REMOVEFILTERS : • ALL Vs REMOVEFILTERS D...
👉12.TOPN Dax Usage : • TOPN Dax | How to use ...
👉13.Summarize Dax Function in Power BI: • summarize dax | How to...
👉14.Summarize Vs Summarizecolumn : • summarize vs summarize...
👉15.Calendar Vs CalendarAuto : • Calendar Vs Calendar A...
👉16.How to create a date table in Power BI : • how to create a date t...
👉17.How to calculate Running total for date values in Power BI
• How to calculate Runni...
👉18.How to default your slicer to current year/Month (Method 1 using custom visual) : • How to Set Default Sli...
👉18.How to calculate running total in power bi for non date values: • Running Total in Power...
👉19.Usage of datediff in Power BI: • Power BI datediff dax ...
👉20.Isblank() Vs Isempty : • Power BI ISBlank DAX F...
👉21.Power BI Scenario based Qn A : • Power bi scenario base...
👉22.Power BI Interview Question (SWITCH function in FORMAT): • TCS🔥Power BI Scenario ...
👉23.Power BI Interview Question - Format Negative values: • Power BI Scenario base...
👉24.Power BI Interview Question - Optimized France sales using SUMMARIZE & FILTER Function
🔥🔥Learn Power BI through our vlog and Free Videos:🔥🔥
powerbizone.co...
❤️❤️Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥
Mail your Queries at : yourpowerbizone@gmail.com
Chapters:
0:17 :Scenario Explanation
0:39 :Usage of SUMMARIZE Dax
1:41 :Using FILTER outside SUMMARIZE
2:51 :Using FILTER inside SUMMARIZE (Optimized)
3:52 :Subscribe
Download this pbix for practice from below link :
drive.google.com/file/d/1RhjrmblKLg7SYHZ68LS_rhnjDK295t3p/view?usp=sharing
You can send all your Interview Questions to yourpowerbizone@gmail.com
❤❤Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥
Great video as always.please keep the interview questions coming 😂
thanks so much !
awesome, really great tip it is. please do more videos on DAX functions in power bi.
Thanx Prabhu ..Sure..and if you or your friends have any interview questions.Do mail them to me with company name so that we can help other candidates
@@powerbizoneyes surely
:)@@prabhurajaram