KPMG: Scenario based Power BI Interview Question | DAX | Window()
HTML-код
- Опубликовано: 14 окт 2024
- Topmate Link to book call 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
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]
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 👏
@@learnwidgiggs Have you created Calendar Table Also in this Case ?
Stock status =
Var Demand = CALCULATE(SUM('Table (2)'[Dem]), FILTER(ALL('Table (2)'),'Table (2)'[Wk]
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 🙏😊
Welcome rajat 😊
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]
Thanks for your alternative answer 👏
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]
We can also use : running T for demand = calculate(sum(demand), filter(all(sheet1), week
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.
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
Finished watching
Inventory = var demand = CALCULATE(SUM('Table 1'[Total Demand]), FILTER(ALL('Table 1'),'Table 1'[Week ]
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")
Its a cumulative total..so it will be out of stock.
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
You can check out Curbal or SQLBI channel.
Ww cam also do by using quick measure snd selecting running total fucntion
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 .
Noted.thanks
Hi Shashank i watched all your 32 videos it was fantastic videos that i have learned thanks a lot
Welcome😀
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")
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.
Eagerly waiting for your success 🙂
Noted your point.
@atulbihari7473 brother are you fresher or experienced person???
@@akshaygupta2398 I have 7+ years of experience.
How to Creat sum of Demand measure please guide?? and can you please provide data set (I have creat but its not work)
Make some video on use relationship dax to make an inactive relationship to active relationship.
Already uploaded on this channel. Plz check out the channel.
@@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?
@@learnwidgiggsThank you found it.
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
Hello bro, can we use generateseries function to do the same?
Try it out. I'm doubtful
Thanks a lot shashank. Keep up the good work.🙂👍
Welcome 😊
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.
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.
I created and tried doing the same but it did not work its not providing the cumulative sum of the demand or supply col
Hello Shashank is there any way of getting connected with you do you conduct any interview sessions for 4 years of experience guy
I take mock interviews..so people who wish to take a mock..they book a session on Topmate (Link in about section of the channel)
@@learnwidgiggs thank you
Thank you so much for your videos,that helps me a lot in getting an offer from Mercedes benz❤
Congratulations rupesh ❤️
That's great!! So what are the skills they have expected in the interview ?
And any vacancy right now there?
bhai interview process bata de please
Tried with switch and if , its not working but with if , switch and running total possible
okay, good to hear that.
Its like running total.why dont we use running total measure here
Running total is part of the problem not he complete solution...plz watch the video again.
Is there any other way of doing it?
there should be "instock" for week 5
No, it should be out of stock.
Plz watch it again and understand the explanation properly.
@@learnwidgiggs If the condition is demand >= supply Then week 5 is instock ?
@@vinays3190 Count the total demand till that week ..not that particular week demand and so it will be out of stock
@@learnwidgiggs
sir if we think like that then for week 3 is "InStock" because 1000 supply fullfill the week 3
I'm I Right?
How many Rounds will be there in KPMG for Powerbi interview
2 technical rounds in general
@@learnwidgiggs hi sir have you got selected in that interview ?
What does 'zero' mean in 'to' argument ?
Current row
Hi sir can u please share data file for practice this dax which will be more helpful
Not working for me!!!
I have loss 3 hours for this video but not working properly.
Why speak OK so many times 😮
Amazing
there should be "instock" for week 5
No, plz watch it again
Count the total demand till that week ..not that particular week demand and so it will be out of stock
@@learnwidgiggs Till that week means , Can we consider whole iterative demand from 1st week to 6th last week?