TCS🔥Power BI Scenario based Interview Question & Answer 🔥SWITCH function inside FORMAT
Vložit
- čas přidán 10. 07. 2024
- 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 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...
🔥🔥Learn Power BI through our vlog and Free Videos:🔥🔥
powerbizone.com/category/arti...
❤️❤️Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥
Download the pbix file from :
drive.google.com/file/d/1Rhjr...
Mail your Qn A to yourpowerbizone@gmail.com
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
Download this pbix for practice from below link :
drive.google.com/file/d/1RhjrmblKLg7SYHZ68LS_rhnjDK295t3p/view?usp=sharing
Iink for learning complete FORMAT DAX usecases : dax.guide/format/
You can send all your Interview Questions to yourpowerbizone@gmail.com
❤❤Do not forget to Like ,Subscribe and comment which keeps me motivated !🔥🔥
little simple way to avoid any confusion between the currency and percentage, we can use the below dax to create calculated column
Output = FORMAT(Sheet1[Mixed], SWITCH(Sheet1[Type], "Decimal", "$00.00", "Percentage", "00.00%"))
Really Informative..I will mail you the interview questions that I recently faced in Wipro and Mindtree
thnx a lot :)
Could you also state the difference between Import and Direct Query? Sometimes it is very confusing to understand.
thank you for your comment Swati ..As the name suggests Import means a copy of the data gets imported to your local Power BI desktop .While in direct query there is no role of local ,you are directly querying the underlying data source (lets say its Azure ,sql server ,oracle etc ).
@@powerbizone Could you please differentiate between all three modes of data connectivity and in what ways, these questions can be asked during interviews.
Sure.I will try to mke a video on this topic.As of now please go throgh the below link:
radacad.com/directquery-live-connection-or-import-data-tough-decision
I have a few interview questions from IT major companies.Whats your Gmail id?
Its yourpowerbizone@gmail.com .Thanks for your help ! Much appreciated
@@powerbizone You are doing a great job.Keep it up
@@saltpepper9062 thank you so much :)