Download link to the pbix File used in this video . drive.google.com/file/d/1RrDAJaQIexFC7hOhoTDR1P6eNBs-0pl_/view?usp=sharing
@nilimagoyal
3 ай бұрын
Grt Video Sir
@powerbizone
3 ай бұрын
thnx Nilima :)
@manjumondal506
4 ай бұрын
Excellent video . Your content is top notch
@powerbizone
4 ай бұрын
thnx :)
@saalimtamboli4272
5 ай бұрын
For the scenario 2 and 3, Can you please tell....What if they wanted the result to be dynamic, means if they changes the order of the columns in the visual, the measure should automatically return the first non blank value without changing the measure again and again, is this possible ?
@beingrishi6450
7 ай бұрын
10:36 can you help me out I didn't understand the question of this particular scenario asked in PwC
@powerbizone
7 ай бұрын
Thank you for your question. .The interviewer is interested in getting the list of those countries which are present in the 1st table (or left table ) but not in the second one .Hence you need to exclude the intersection part also.Hence both germany and france should not be a part of the answer .Hope this helps !
@beingrishi6450
7 ай бұрын
@@powerbizone got it... This asked in PwC recently? Actually I'm preparing interview questions patterns for PwC can u share the list of scenarios based questions covering in interview ! I all covered your videos
@beingrishi6450
7 ай бұрын
13:14 what is the proper question being asked for this particular scenario asked in PwC
@beingrishi6450
7 ай бұрын
Got it... I understood... Left anti join usage of getting unmatched records
@beingrishi6450
7 ай бұрын
Got it... I understood... Left anti join usage of getting unmatched records
@powerbizone
7 ай бұрын
Its the same question that i have mentioned above .However this is the second way to solve the question using DAX's '"EXCEPT".If you are comfortable with sql .Do visit: stackoverflow.com/questions/57899419/how-to-show-only-the-left-part-of-the-tablenot-intersecting-section-in-left-jo
@powerbizone
7 ай бұрын
@@beingrishi6450 🙂
@powerbizone
7 ай бұрын
:)@@beingrishi6450
@CarlosVolpe-w1n
8 ай бұрын
Bhai please upload longer videos related to interview preparation for a Data Analyst role covering SQL, Python, Power BI and Excel
@powerbizone
8 ай бұрын
thnx for the feedback bro .Also will try to create a playlist of all the important pbi qna .Do share this video with your frends if you find this useful.
Пікірлер: 18