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.
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 !
@@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
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 ?
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
Download link to the pbix File used in this video .
drive.google.com/file/d/1RrDAJaQIexFC7hOhoTDR1P6eNBs-0pl_/view?usp=sharing
Grt Video Sir
thnx Nilima :)
Excellent video . Your content is top notch
thnx :)
Bhai please upload longer videos related to interview preparation for a Data Analyst role covering SQL, Python, Power BI and Excel
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.
10:36 can you help me out I didn't understand the question of this particular scenario asked in PwC
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 !
@@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
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 ?
13:14 what is the proper question being asked for this particular scenario asked in PwC
Got it... I understood... Left anti join usage of getting unmatched records
Got it... I understood... Left anti join usage of getting unmatched records
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
@@beingrishi6450 🙂
:)@@beingrishi6450
why not inner join?