Power BI Interview | Scenario to calculate DYNAMICALLY TOP 'N' values

Рет қаралды 23,118

Жыл бұрын

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

Пікірлер: 74

@rajatdixit11 Жыл бұрын

This question was asked to me recently in Power BI interview in 2 of the Big 4 firms recently!! 😊

@bidhanry9740 Жыл бұрын

hi rajatdixit11, if you don't mind could you please give me all the question you have faced in power bi interview?

@sivakrishna_preneur 4 ай бұрын

How sashank was created buttons which are top 2 , top 3 and top 5?

@mahendrapal3413 4 ай бұрын

@@sivakrishna_preneur I am also think that slicer which he is using top 2 top 3 top 5 is alrady availble in table or created

@sivakrishna_preneur 4 ай бұрын

@@mahendrapal3413 go through buttons and selection concepts

@dhrutijoshi3701 Жыл бұрын

Take a bow , I was searching for this for one challenge but at that time I couldn't do it. Finally got this now ...keep sharing such videos

@learnwidgiggs Жыл бұрын

Thanks 😊

@vikassolanki297 9 ай бұрын

Rnk2 = var a1= If(HASONEVALUE(Orders[Product Name]),RANKX(All(Orders[Product Name]),[Total Sales],,DESC,Dense)) var a2 = If(a1

@learnwidgiggs 9 ай бұрын

Great 👍

@ramshataqdees5570 7 ай бұрын

please explain

@rajatdixit11 Жыл бұрын

Great content! As always.. Thanks a lot for your efforts 😊

@learnwidgiggs Жыл бұрын

My pleasure!

@suruvumohan583 Жыл бұрын

Hello, another way is there. Thanks for your great videos and information

@learnwidgiggs Жыл бұрын

You are welcome!

@JayeshTatipamul Жыл бұрын

Helpful Video.

@learnwidgiggs Жыл бұрын

Glad it was helpful!

@Regans5677 10 ай бұрын

hai while using this dax syntax is running correct but not showing data under the coloums ,just colomn names only, showing,can you plz correct this

@KiranKumar-rd1is Жыл бұрын

Bro, Thanks for the video. Could you please share the Pbix file or data to practice.

@subbaraoballipale890 5 ай бұрын

u can use filter fun directly right for top 3 5 6 & relatable fun

@vikassinghjayara510 Жыл бұрын

I have learned a lot from you and adding a new skills everyday. This series is very good. Lot's of love from Delhi 😍 Sir, I am practicing all the videos of this series and preparing myself for PowerBi job interview. Can you please share more interview questions on other parts of PowerBi like Power View, Model, Power Query etc.

@learnwidgiggs Жыл бұрын

plz watch the first 8 videos of this playlist : kzfaq.info/sun/PLk-s1KYuT-Pk2a1mbFe-nH7BNVdQjsWVU

@vikassinghjayara510 Жыл бұрын

@@learnwidgiggs Thank you so much Sir. 😍 Will you upload more questions on that playlist? Or those questions are enough?

@learnwidgiggs Жыл бұрын

Currently you will find more videos on scenario based questions which are frequently asked.

@vikassinghjayara510 Жыл бұрын

@@learnwidgiggs Thank you Sir for your valuable efforts. Nowadays, I am in a difficult time, therefore, asking that questions. I appreciate your work and the time which you are giving us.

@learnwidgiggs Жыл бұрын

No worries

@swapnilgupta2496 2 ай бұрын

Well explained bro but you are making it more complex instead we can add the calculate column in both the tables create the relation ship and then write a simple measure, it should not be that complex and it is not good to write these many dax

@rajunalgunta6106 Жыл бұрын

@LearnWidGiggs is most valuable asset for students

@learnwidgiggs Жыл бұрын

Glad to hear this 😊

@laxmankumar3388 7 ай бұрын

it has a context transition error. when we select top 2 on slicer. Total should be change but it's showing overall sale.

@monishpilla4137 Жыл бұрын

Thank you for the video what if the client wants top 2,l least 3, least 6, in the slicer.

@learnwidgiggs Жыл бұрын

We have to modify the measure accordingly.

@SonuSonu-uh2er Жыл бұрын

Can u prepare video on what are the steps followed by the Power BI developer while building a report like SDLC in software making.

@learnwidgiggs Жыл бұрын

okay, will plan.

@bindooo Жыл бұрын

bro can you make a video on power bi with SQL server as a data source, like how to import and details that are being asked in the interview. this is widely asked in interviews nowadays.

@learnwidgiggs Жыл бұрын

Noted.

@debapriyasaha5547 Жыл бұрын

Hi Shashank sir. Please start power bi live classes it will be helpful to many aspirant

@learnwidgiggs Жыл бұрын

Will try, thank you for suggesting

@rojalibiswal8975 11 ай бұрын

could u provide data set

@nareshtekchandani2188 8 ай бұрын

Hi Shashank, Keep up the good work 👌👌 also, I want to understand while selecting the top 2 and top 3 and top 5 the total sales remained the same the total was showing for all the sales. can you help me with that?

@learnwidgiggs 8 ай бұрын

If total is not working fine then measure has to be readjusted ..to make measure work for total also correct

@ranjith1083 Жыл бұрын

please guide me, my rank list should be applied only for column values and not for total...so how this can be achieved

@ashokreddy3300 Жыл бұрын

Use rankx function

@abhinavjha3840 3 ай бұрын

how did you created that buttons for top 2 , top 3 and top 5

@learnwidgiggs 3 ай бұрын

You can create a table in and enter those values manually

@sureshboddana33 Жыл бұрын

hi bro how u link siler and topn values dax function relation. Could you please tell me . i cant get when i am trying

@learnwidgiggs Жыл бұрын

Can you tell me what part of the video you didn't understand

@sureshboddana33 Жыл бұрын

@@learnwidgiggs i got bro . I have one scenario which is asked by PWC interview. I am unable to crack . could you please help me. If provide your email address. I will explain to you

@nishantpurohit100 Жыл бұрын

But the total is not changing, it should change as well, anyways nice video, appreciate your efforts.

@learnwidgiggs Жыл бұрын

Thank you.

@sureshsonti8097 Жыл бұрын

Hello Sir, I have question regarding the Total. If the Top 2 is selected, I get the B and D but the total is still 4445. How can I get the Total 2240. Thanks

@learnwidgiggs Жыл бұрын

Usually we don't show the totals but if you have to show then Dax code has to be modified and will upload a separate video on this.

@vinodshinde8468 Жыл бұрын

Sir without using rankx also we achieve dynamic topn right sir please correct if I m wrong

@learnwidgiggs Жыл бұрын

Umm...you may also make use TOPN function in some way...you do it in some other way if possible and let me know and our audience plz.

@tejaschaudhari9781 7 ай бұрын

This scenerio based question is for experienced one candidate or also for a Fresher candidate ....please reply sir!

@learnwidgiggs 7 ай бұрын

Mostly experienced

@ramshataqdees5570 7 ай бұрын

will question like these be asked to less than 2 year of experience

@learnwidgiggs 7 ай бұрын

>=2 yrs

@lakshminarayana3168 10 ай бұрын

How to share interview questions which i faced recently

@learnwidgiggs 10 ай бұрын

You can DM me on LinkedIn or you can send a mail..mail id there in the About section of the channel

@anasahmad5415 Жыл бұрын

do you teach live classes ? if yes then would ike to take classes

@learnwidgiggs Жыл бұрын

Don't take any Live classes as of now.

@reddyjogireddy6425 Жыл бұрын

Sir , what you wrote in top n values

@learnwidgiggs Жыл бұрын

At what point of time in the video?

@ashokreddy3300 Жыл бұрын

Give me your contact,bro so together we can prepare

@kalyanibagal1849 Жыл бұрын

name city sales A 1 12 B 2 16 C 3 18 D 4 19 E 5 81 Suppose I have these 3 columns....and I want to add one column...and the condition is 12/(12+16+18+19+81).....like this ....how can we write dax for this

@kalyanibagal1849 Жыл бұрын

Each time we have to divide sales by sum of all sales

@learnwidgiggs Жыл бұрын

Try this : Measure = Divide(tablename[sales], Sum(tablename[sales]))

@kalyanibagal1849 Жыл бұрын

@@learnwidgiggs I want to add column

@reddyjogireddy6425 Жыл бұрын

Give the rank on the basis of sales

@reddyjogireddy6425 Жыл бұрын

Then add by rank wise

@venusagarla4052 Жыл бұрын

Helo sir, Pls provide pbix file aslo to practice around.

@provider65 Жыл бұрын

Share your contact bro, together we prepare

@ankushjain4128 Жыл бұрын

You are doing fabulous job ,your question collection is really good can relate in real powerbi interview questions .Please keep it up Here i think instead of using switch we can easily achieve same result in one line of code if([ranking]

@learnwidgiggs Жыл бұрын

Thanks for the solution,, hope it works.