Accenture: 2 Tricky Scenario Based Questions | Power BI Interview

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
#powerbiinterview
#learnwidgiggs

[@shreelakshmibhatt1617]

Measure = COUNTROWS(FILTER('Sales', 'Sales'[sales value] > 500))

[@prathameshmunj4768]

I think you should write countrows(filter(values(sales[product]), [total_sales]>500). if the products are duplicate in table then this will be useful.

[@foryoutube2563]

Thanks for the videos. One suggestion though for the second problem it could have explained what is trying to achieve. Answer was simple if problem was explained properly.

[@rajatdixit11]

Very nice video...Every video filled with great quality content 😊🙏

[@learnwidgiggs]

welcome 🙂

[@vamshiabhilash]

@rajat jingala la la la

[@srikanthjella9133]

bro can you please do two videos 1. modelling in power bi . if i will give you some tables right sometimes the data is not floating correctly do u know how do you handle the . sometimes we have to give multiple relationships sometimes data filtering not connecting correctly di you know how to troubleshoot 2. before migration to power bi being a senior power bi resource what is the pre-requisites that you think that needs to be fulfilled or needs to be checked as a senior developer when you have free time can you please do these two videos thank in advance :)

[@learnwidgiggs]

Noted.

[@maheshtiwari2297]

There are different steps that you do. 1. Identify the problematic column by doing transform or you can say power query editor. 2. Data type formatting 3. Handle missing or null values 4. You can even use conditional formatting in order to check incorrect data

[@rakeshgunakala7460]

Bro add the scenarion based questions in the description

[@shanmukhasrinivas9473]

Thank you so much brother for this video...

[@learnwidgiggs]

Welcome 🙂

[@vijaychilkewar4239]

Like your videos. please keep uploading often

[@learnwidgiggs]

Welcome 🙂

[@JayeshTatipamul]

Very helpful video.

[@learnwidgiggs]

Thank you 😊

[@umasankar3369]

Thank you ❤️

[@learnwidgiggs]

Welcome 🙂

[@shomiksarbabidya2712]

Can you please explain why we can't use measure as a filter parameter in calculate function?

[@theoldvocals266]

You can use it inside the filter function.

[@draco1847]

Thanks ❤️

[@learnwidgiggs]

You're welcome 😊

[@sandeepmanjunath8004]

Can we use keepfilter here as calculate modifier ?

[@learnwidgiggs]

Yes, It should work.

[@mahi.248]

Sir, in 3 years how many reports, dashboards, projects are created?

[@learnwidgiggs]

Depends on you

[@shivanshaghor8443]

5-8 projects depending on the project type.

[@tatipamulaashok5721]

Good examples with nice explanation..

[@learnwidgiggs]

Glad you liked it!

[@saudagarpatil5743]

Sir I want to calculate last 2 hours sale How can I calculate this by using Dax function

[@learnwidgiggs]

Plz watch this video to get the answer: kzbin.info/www/bejne/iKCmnYl4bZKkopY

[@Dishita123]

Is it possible to find average in this way Feb,Jan=(2+1)/2 March,Feb,Jan=(3+2+1)/3 like this...

[@learnwidgiggs]

didn't understand yr query

[@Dishita123]

@@learnwidgiggs if I select any month i want average calcution of all backward months upto first month

[@SSRealEstates83]

4 fact tables, no primary key column in any table, no dim tables...I think we need to create dim tables from fact tables,...how to get one to many relationship...now fact to fact tables ...all are many to many....how I can handle this situation....

[@learnwidgiggs]

You need to take out dim table columns from fact table into a new table and then make 1 column which is the most suitable one as primary key column by removing the duplicates and then make the relationships

[@SSRealEstates83]

@@learnwidgiggs Thanks for your speedy reply...can you please make a video on that...it will be very helpful to the Power BI developers

[@Rudra_Gaming10.]

First you take dim table column from fact table as new table nd then inside new table remove duplicates nd then take new index column and then merge this index column with your fact table 🙏

[@SSRealEstates83]

@@Rudra_Gaming10. thank you

[@manojpatil8189]

Use TREATAS function

[@onkarkudale7382]

How to rename table visual cell value but not affect in dataset ?

[@learnwidgiggs]

You can rename column names not the data values

[@onkarkudale7382]

@@learnwidgiggs no sir I want to rename the data value

[@missbutterfly1190]

How many rounds do we have in Accenture interview process ?

[@learnwidgiggs]

In general 1 technical (1hour)+1 managerial+1 HR

[@missbutterfly1190]

@@learnwidgiggs thanks for the info. In managerial round will they ask any power bi related questions

[@akshayshirbhate7]

😊😊🙏

[@shekharshete9433]

It is a possible to get a job in power bi as a fresher

[@learnwidgiggs]

Possible - yes but in the current situation it is a little difficult

[@shivanichaudhari9095]

This is for what yoe??

[@learnwidgiggs]

2 yrs

[@sreemalapal]

Hi..I have scenario for you..Request you to make a video on this pls .. This may be a very simple task for you..But for beginners it can be challenging.. Scenario- I have an excel file with a col as Product Name. The name includes - Brand name, product (eg - milkshake, atta), qty (100 g, 2lit), packaging type ( eg - Bottle, Can). This entire information is in one col. I need 4 different columns as Brand, Item, Qty, Packaging type. I can share the sample dataset for your understanding

[@learnwidgiggs]

Noted!

[@balaji_prabhu]

i think this can be done option like “colum as example “ in power bi please correct me if i am wrong

[@missbutterfly1190]

We can achieve it by splitting the column by delimiter. If they are comma separated