KPMG: Scenario based Power BI Interview Question | DAX | Window()

Подписаться 56 тыс.

Просмотров 17 тыс.

50% 1

Topmate Link to book call 1:1 - topmate.io/learnwidgiggs
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

Опубликовано:

23 апр 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 70

@sandeepsandy5286 Год назад

Hi bro thanks for bringing up windows() but we can also solve this by doing simple dax IN/OUT Stocks = var running_week = CALCULATE( SUM([Total demand]) , FILTER( ALL(supply), supply[week]

@learnwidgiggs Год назад

Yeah alternate way is also there..but you can see your DAX code length...so it's better to use short codes. And glad to see your alternate way 👏

@shubhamkumartanwar4355 3 месяца назад

@@learnwidgiggs Have you created Calendar Table Also in this Case ?

@sidmoitra007 Месяц назад

Stock status = Var Demand = CALCULATE(SUM('Table (2)'[Dem]), FILTER(ALL('Table (2)'),'Table (2)'[Wk]

@rajatdixit11 Год назад

Got to learn a lot from this example! Wasn't aware of this DAX before watching this..Thanks a lot brother for your valuable addition to Power BI community 🙏😊

@learnwidgiggs Год назад

Welcome rajat 😊

@HappyAnalysing Год назад

Hi Bro, Thank you doing all these helpful videos. We can achieve this without using Window function as below: Demand & Supply = var demand = CALCULATE( [Total Demand], FILTER( ALLEXCEPT( 'Table', 'Table'[Demand] ), 'Table'[Week]

@learnwidgiggs Год назад

Thanks for your alternative answer 👏

@kandlakutisaiharshavardhan8429 6 дней назад

Hi @LearnWidGiggs Community I think there is some mistake in the final measure which is "Inventory Output" for week "4" the total running demand is 1400 But the available supply is 1000 . But in final result it still says we have " INSTOCK" Actually it should show "outofstock". Could you please check that and correct me if I my understanding is wrong

@user-lm5wb8vi1x 11 часов назад

Finished watching

@sidmoitra007 Месяц назад

Hi, Thanks for sharing windows function, I tried it slightly differently: Stock status = Var Demand = CALCULATE(SUM('Table (2)'[Dem]), FILTER(ALL('Table (2)'),'Table (2)'[Wk]

@Winter_Soldier100 3 месяца назад

Great videos and you pick the most important concepts and examples. Just a small suggestion, please include the dataset as many of us would understand and work better if we get the same dataset.

@gudaprasanna9986 Год назад

Thanks a lot shashank. Keep up the good work.🙂👍

@learnwidgiggs Год назад

Welcome 😊

@srikanthjella1458 Год назад

Hi Shashank i watched all your 32 videos it was fantastic videos that i have learned thanks a lot

@learnwidgiggs Год назад

Welcome😀

@MultiDeepjyoti Месяц назад

Ww cam also do by using quick measure snd selecting running total fucntion

@himanshubasra4451 3 месяца назад

We can also use : running T for demand = calculate(sum(demand), filter(all(sheet1), week

@atulbihari7473 Год назад

Thank you so much for your videos. Your videos helped me a lot in understanding the core concepts of Power BI. I have given multiple interviews but not selected yet, will update if I get selected. It will be helpful if you can create videos on Deployment Pipeline, Alerts and Usage Metrics.

@learnwidgiggs Год назад

Eagerly waiting for your success 🙂 Noted your point.

@akshaygupta2398 Год назад

@atulbihari7473 brother are you fresher or experienced person???

@atulbihari7473 Год назад

@@akshaygupta2398 I have 7+ years of experience.

@RupeshKumar-dh3ig Год назад

Thank you so much for your videos,that helps me a lot in getting an offer from Mercedes benz❤

@learnwidgiggs Год назад

Congratulations rupesh ❤️

@nivii2656 Год назад

That's great!! So what are the skills they have expected in the interview ? And any vacancy right now there?

@indergaming3053 10 месяцев назад

bhai interview process bata de please

@as8401 8 месяцев назад

How to Creat sum of Demand measure please guide?? and can you please provide data set (I have creat but its not work)

@sonalijain9024 Месяц назад

I have one query while there are no values in total supply so when we calculate total supply it is throwing an error.Can u plz explain this

@DilipAghav 7 месяцев назад

Amazing

@Surmabhopalii Год назад

Hi where i can learn dax, the level of knowledge you have for dax is excellent....i am new to this community and now trying to learn power bi have basic dax knowledge available on some tutorial but like you used in your scenario based video i also want to learn please help and guide

@learnwidgiggs Год назад

You can check out Curbal or SQLBI channel.

@twinklymyra 2 месяца назад

I created and tried doing the same but it did not work its not providing the cumulative sum of the demand or supply col

@vishalsonawane.8905 6 месяцев назад

Hello Shashank Sir, Could you please explain, how is it possible week 5 is in outoff stock because (week 4,1000-700 =300, "Stock"),( week 5, week 300-300 =0 "Stock")

@learnwidgiggs 6 месяцев назад

Its a cumulative total..so it will be out of stock.

@ManpreetSingh-mn2zd 17 дней назад

Inventory = var demand = CALCULATE(SUM('Table 1'[Total Demand]), FILTER(ALL('Table 1'),'Table 1'[Week ]

@rishihanchate7458 5 месяцев назад

Is there any other way of doing it?

@srikanthjella1458 Год назад

when u have free time please do two videos sir 1. Before migration to power bi being a power bi developer what is the pre-requisites that you think that needs to be fulfilled or that needs to be checked as developer 2. In modelling in power bi if i will give you some tables right sometimes that data is not floating do you know how to handle it sometimes we have to give multiple relationships sometimes not allowing and sometimes data filtering not connecting correctly do you know how to troubleshoot thanks in advance .

@learnwidgiggs Год назад

Noted.thanks

@vishalsonawane.8905 Год назад

Running_T_Demand = CALCULATE([Total_Demand_1],WINDOW(1,ABS,0,REL,ALLSELECTED(Inventory_Details[Week]))) ....i have try to same but its not working.

@learnwidgiggs Год назад

Don't know why sometimes it doesn't work on yr machine becoz I clearly showed the same thing in the video and it worked. Just try to debug properly,,something is there which you are not able to see.

@saurabharya2892 11 месяцев назад

Hello bro, can we use generateseries function to do the same?

@learnwidgiggs 11 месяцев назад

Try it out. I'm doubtful

@Travelwithus304 4 месяца назад

Make some video on use relationship dax to make an inactive relationship to active relationship.

@learnwidgiggs 4 месяца назад

Already uploaded on this channel. Plz check out the channel.

@Travelwithus304 4 месяца назад

@@learnwidgiggs I didn’t able to find it in your channel. I am daily viewer of your channel.Can you paste the video link here?

@Travel.is_fun 4 месяца назад

@@learnwidgiggsThank you found it.

@nikitadharbale9229 10 месяцев назад

Hi sir can u please share data file for practice this dax which will be more helpful

@kastenivkimbo5347 Год назад

Tried with switch and if , its not working but with if , switch and running total possible

@learnwidgiggs Год назад

okay, good to hear that.

@user-lu5cy5gv9v 2 месяца назад

Hi Bro, Result is not coming as expected. Demand = Sum(Inventory[Total Demand]) Supply = sum(Inventory[Total Supply]) Running T Demand = Var demand = CALCULATE([Demand],window(1,ABS,0,REL,ALLSELECTED(Inventory[Week]))) Var supply = CALCULATE([Supply],window(1,ABS,0,REL,ALLSELECTED(Inventory[Week]))) return if (demand > supply,"Out of Stock","Instock")