Deloitte: Scenario based Power BI Interview Question | Part 3

Topmate Link to book session 1:1 - topmate.io/lea...
Link for the Scenario based QnA in Power BI: • Scenario based QnA - P...
Link for the Power Bi Interview QnA playlist :
• Power BI Interview QnA
Link for the SQL QnA playlist :
• SQL Interview QnA for ...
Link for the Data Warehousing QnA playlist :
• DW Concepts Based QnA
☀ Connect with me Here on Social Media ☀
LinkedIn : / shashank-singh-🇮🇳-ba4b...
Instagram : / shashank_nikumbh26
Your queries:
power bi interview questions
power bi interview questions and answers
power bi interview
power bi interview questions for experienced professionals
power bi interview questions for freshers
deloitte power bi interview questions
power bi scenario based interview questions
power bi service interview questions
scenario based power bi interview questions
power bi practice scenarios
power bi real time scenarios
shashank singh power bi
power bi scenario based questions
sql and power bi interview questions
capgemini power bi interview questions
accenture power bi interview questions
power bi managerial round interview questions
how to explain project in power bi interview
power bi roadmap
power bi jobs for freshers
power bi project explanation in interview
power bi resume for freshers
power bi fresher jobs
power bi resume
power bi developer resume
power bi resume for 2 years experience india
power bi developer resume for experienced
#powerbiinterview
#learnwidgiggs

[@namangarg7875]

Summarizecolumn added to my dictionary. Thanks sir!

[@learnwidgiggs]

You're welcome!

[@UmaMukherjee-y4l]

Excellent Shashank

[@Vishnupriya_28]

Excellent Explanation. Thank you Shashank.

[@itachiuchia6294]

calculatedtable(table1,productid=500)

[@ranjithkumar-wb5ft]

Good explanation...got full clarity

[@learnwidgiggs]

Glad to hear this 😊

[@trikavyam8101]

Its really help full

[@learnwidgiggs]

Glad to hear this 😊

[@RiyazKhan-zz8fq]

Custom_Table = var a =CALCULATETABLE(Products,Products[ProductKey]

[@praveenguduru160]

SUMMARIZECOLUMNS( 'Sumamrize Table'[Product ID], 'Sumamrize Table'[Product Name], 'Sumamrize Table'[Price], FILTER( 'Sumamrize Table', 'Sumamrize Table'[Product ID] = 500 ) ) I think this is the more optimized code in above scenario

[@nithin5625]

Great video . But the product name should start with "S" if we use search it will give products if the product name contains S (In the middle or end). So isn't is more appropriate to use LEFT('Sumamrize Table'[Product Name])="s". i.e. New Table = CALCULATETABLE( SUMMARIZECOLUMNS( 'Sumamrize Table'[Product ID],'Sumamrize Table'[Product Name],'Sumamrize Table'[Price] ), 'Sumamrize Table'[Product ID]= 500 )

[@learnwidgiggs]

Yes, you can try this also.

[@LearningNeverEndz]

@nithin5625 - this DAX will pick only that product where name is starts with small letter 's' , right?

[@chaitanyakurlekar9050]

When I use Left then it says cannot convert value 'F' of type text to type True/False. Then what should be my data type for product name

[@krishbala9822]

Exactly

[@samarthkhurana7321]

can we do this by using filter dax function i think it will make a seprate table with the given condition

[@learnwidgiggs]

you can try out

[@moderncollectionkalyan3280]

In Concentrix I got question , You are fetching your excel data from folder A.Now you change your folder from A-B..You need to give path of folder B but you also need al files from A also. 1- we mght think like that copy folder A files into B,But It will affect your model performance.what will yoou do in this situation?

[@learnwidgiggs]

Pull the folder in power query and append it with the new folder files

[@moderncollectionkalyan3280]

@@learnwidgiggs It will take time to load. Again you will load files that are in folder A. It will affect model performance. May be incremental refresh will be the answer. From folder B he need only new fike to load at PBI. But folder B is containing all files that are in A and B

[@AzamKhan-nb1op]

Table1 = FILTER(Products,Products[ProductKey]

[@lalithkishore6442]

This will return all the columns, only 3 columns is needed

[@PushpenderSharmaGreyB]

new table = SELECTCOLUMNS( filter('Sheet1 (2)','Sheet1 (2)'[OrderID]

[@NaveenKumar-fq4sb]

More helpful pls continue...

[@learnwidgiggs]

I will thanks.

[@vishaldindurkar9109]

The Search() will pull those records as well which don't start with "S" but contains "S" or end with the "S", right? If we want to use similar to SQL -> Like 'S%' then how we can achieve this?

[@learnwidgiggs]

The records that I have used here..Search() has worked but yes you are right Search () would work even when the record contains 's' anywhere so in that case I believe Left() would work.

[@vishaldindurkar9109]

@@learnwidgiggs that's right I was thinking the the same, left should work in this case. Will try. Thanks for the prompt response.

[@Jo.gg789]

can we use for last argument ==> search("s",[column],1,blank()) = 1

[@krishbala9822]

@@learnwidgiggs sure sir

[@krishnakantapanda6835]

Amazing

[@learnwidgiggs]

Thank you.

[@Mr.benjamin_netanyahu]

Sir I asked one scenario on your linkedin account. Q) there is 4 years sales data in matrix visual and we take one slicer and put the month in it. so if we select january2019 in slicer so it has to be fetch the january month data with past 2 month data (november and december also) in matrix visual.. so what will you do? which dax will you use in it?

[@learnwidgiggs]

Yeah, it's there in my To do list.

[@praveentanikella4078]

I need DAX basic to advanced badly not getting idea how to do please let me know. Thanks

[@learnwidgiggs]

Take some course from Udemy and practice.

[@rajatdixit11]

Good scenario 🤠

[@learnwidgiggs]

Indeed, thanks 😊

[@beingbeautiful2680]

Helpful😊

[@learnwidgiggs]

Glad to hear it 👍

[@hajar4367]

One Interview question I got something like . Convert SQL query into DAX: Select distinct empname, Department from emptable. Could you write a DAX query for it.

[@trikavyam8101]

EVALUATE ( SUMMARIZECOLUMNS ( 'emptable'[empname], 'emptable'[department] ) )

[@learnwidgiggs]

Use Distinct() also inside Summarizecolumns()

[@priyaagarwal4559]

Thankyou ..really helpfull.

[@learnwidgiggs]

Glad it helped.

[@Mindful_Thoughts-yv6pz]

What if s is not in the begining but in second postion still search gives out put so it does not works

[@Ahmad-yv5zx]

Use this and thanks later LEFT(1) = "S"

[@chenchuladileep7410]

you can use this deloitte resultant = CALCULATETABLE(SUMMARIZECOLUMNS(deloitte[Product_id],deloitte[Product Name],deloitte[Price]), deloitte[Product_id]300,SEARCH("s",deloitte[Product Name],1,BLANK())=1)

[@VinodKumar-lu7ew]

Sir Can You Make A Video On End To End Project Explanation Please.

[@ksrcelluloid]

Hi @learnwidgiggs bro Interview question from Siemens: In a colomn Row 1) apple,bat,cat Row 2) bat, cat,apple Row 3)cat,apple,bat . . . I want to find the how sum of apple,sum of bat, sum of cats I need DAX code for this.

[@learnwidgiggs]

Noted.

[@sathishkumarpati]

I have one question....... I connected with 10 data sources with a report and i published to service. Now I want to refresh only particular source insted of all... How can achieve it

[@nageshbabar5912]

Please make a video on AI in power bi if you can train then I'll pay for it

[@learnwidgiggs]

Could you plz elaborate.

[@nageshbabar5912]

@@learnwidgiggs i am working on project where ai visuals are to be used please make video on AI visuals

[@jayantdarade]

Hi Babar,can you give examples of AI visuals used in your project and what you are trying to achieve

[@chandusekhar7517]

thanks for the videos ...! how can we decide the connectivity type (Import or Direct Query). I know Based on data size Ex. Fetching data from sql server. In this scenario How can we decide which mode is good to connect the source and PBI Desktop

[@sandeepmanjunath8004]

is this possible using selectcolumns with filter function as expression argument ?

[@learnwidgiggs]

I doubt if it could be done this way

[@sandeepmanjunath8004]

@@learnwidgiggs if possible please leave a link to the pbix file that you work on helps us to try out different solutions so we can get better understanding of application of other functions as well

[@sandeepmanjunath8004]

@@learnwidgiggs yes you are right i forgot filter returns the entire table and not just individual column its not possible to do that

[@parshuramvlog1833]

Sir, If product name is BPS1, then it will also return, in this case our criteria will be false. Please suggest for other solution.

[@learnwidgiggs]

No, in this case also Search() will work. Try it out.

[@physicsterminal6534]

Use Left func to extract first letter from product name column inside Search func.

[@physicsterminal6534]

Search("s",Left(Table[productName],1),1,Blank())

[@reshmaappecherla3000]

If an interviewer asks how many power bi reports you have developed in your 3.5 year experience (it's fake experience though), what could be the ans?? He needs number only not the other ans

[@learnwidgiggs]

7

[@reshmaappecherla3000]

Only 7 reports in the entire 3.5 years experience?? How can we even justify it?

[@learnwidgiggs]

@@reshmaappecherla3000 Every report contained 5+ pages

[@vikaskumar-qr5tj]

@learnwidgiggs i tried the below code but it is throwing the same error i.e the expression refers to multiple columns and multiple columns cannot be converted to scalar value could u plz help with this. Filt_Table = CALCULATETABLE( SUMMARIZECOLUMNS( 'Delloite_Scenario'[ProductId],'Delloite_Scenario'[ProductName],'Delloite_Scenario'[Price] ), 'Delloite_Scenario'[ProductId]= 500 )

[@shaheerbaba-0082]

i am also getting same error