TCS🔥Power BI Scenario based Interview Question & Answer 🔥SWITCH function inside FORMAT
In this video we learn about a new Scenario based Interview Question that was asked in TCS.
Basically we see how can we write a dax and convert both decimal and percentage into a single column .
I thank Subham (my linked ln friend) to give me this Power BI Scenario based Interview Question.And request you guys to to also give me support by giving the questions that you are facing in your Power BI interviews.
🔥🔥🔥Check out our other Power BI Tutorials Videos :🔥🔥🔥
👉1.SamePeriodLastYear with Example: • difference between parallelperiod and same...
👉2.How to Calculate Running Totals: • How to calculate running total in power bi
👉3.Duplicate Vs Reference : • power bi difference between duplicate and ...
👉4.Merge Vs Append: • power bi difference between merge and append
👉5.Calculate Function in DAX Power BI: • What is Calculate Function in Power BI DAX...
👉6.Filter Function in Power BI: • Filter Function in Power BI DAX
👉7.Row Vs Filter Context: • Row Context Vs Filter Context in Power BI
👉8.ALL DAX Function: • How to use ALL Dax Function in Power BI | ...
👉9.ALL Vs ALLSELECTED : • allselected dax|all vs allselected dax | p...
👉10.ALL Vs ALLSELECTED VS ALLEXCEPT : • All Vs AllSelected Vs AllExcept | Power BI...
👉11.ALL Vs REMOVEFILTERS : • ALL Vs REMOVEFILTERS Difference in Power B...
👉12.TOPN Dax Usage : • TOPN Dax | How to use topn dax in power bi...
👉13.Summarize Dax Function in Power BI: • summarize dax | How to use summarize in DA...
👉14.Summarize Vs Summarizecolumn : • summarize vs summarizecolumns | how to use...
👉15.Calendar Vs CalendarAuto : • Calendar Vs Calendar Auto Dax Function| Po...
👉16.How to create a date table in Power BI : • how to create a date table in power bi: st...
👉17.How to calculate Running total for date values in Power BI
• How to calculate Running total for date va...
👉18.How to default your slicer to current year/Month (Method 1 using custom visual) : • How to Set Default Slicer selection to Cur...
👉18.How to calculate running total in power bi for non date values: • Running Total in Power BI for non date Val...
👉19.Usage of datediff in Power BI: • Power BI datediff dax Usage with Example| ...
👉20.Isblank() Vs Isempty : • Power BI ISBlank DAX Function with IF Cond...
👉21.Power BI Scenario based Qn A : • Power bi scenario based interview question...
🔥🔥Learn Power BI through our vlog and Free Videos:🔥🔥
https://powerbizone.com/category/arti...
❤️❤️Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥
Download the pbix file from :
https://drive.google.com/file/d/1Rhjr...
Mail your Qn A to [email protected]
Chapters:
0:19 :Interview Question Overview
1:40 :Creating a new Column
1:50 :FORMAT DAX Function
2:25 :Switch DAX Function
2:50 :Usage of Currency inside FORMAT
3:21 :Meaning of % Symbol
4:06 :Closure