Deloitte: Scenario based Power BI Interview Question | Part 3

[@PushpenderSharmaGreyB]

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

[@namangarg7875]

Summarizecolumn added to my dictionary. Thanks sir!

[@learnwidgiggs]

You're welcome!

[@vishnupriya_28]

Excellent Explanation. Thank you Shashank.

[@UmaMukherjee-y4l]

Excellent Shashank

[@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

[@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

[@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

[@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.

[@ranjithkumar-wb5ft]

Good explanation...got full clarity

[@learnwidgiggs]

Glad to hear this 😊

[@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

[@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

[@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.

[@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()

[@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.

[@trikavyam8101]

Its really help full

[@learnwidgiggs]

Glad to hear this 😊

[@VinodKumar-lu7ew]

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

[@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

[@ShonMarsh-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)

[@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

[@krishnakantapanda6835]

Amazing

[@learnwidgiggs]

Thank you.

[@NaveenKumar-fq4sb]

More helpful pls continue...

[@learnwidgiggs]

I will thanks.

[@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())

[@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

[@rajatdixit11]

Good scenario 🤠

[@learnwidgiggs]

Indeed, thanks 😊

[@priyaagarwal4559]

Thankyou ..really helpfull.

[@learnwidgiggs]

Glad it helped.

[@beingbeautiful2680]

Helpful😊

[@learnwidgiggs]

Glad to hear it 👍

[@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