Capgemini- DAX based scenario asked in Power BI Interview😲 | Must Watch

Codebasics Data Analyst Bootcamp Link:
codebasics.io/bootcamps/data-...
-------------------------------------
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 : / learnwidgiggs
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

[@ghoshsubhosmita]

thank you shashank for sharing this

[@user-qi8ez8cn2r]

Great explanation sir

[@shalinisrivastava7250]

Thank you so much sir,

[@AakashYadav-kb2qn]

Thankyou giggs bhai

[@shalakamohite1076]

Thank you sir

[@beneficial4u572]

Very Useful, thanks for sharing.

[@learnwidgiggs]

Glad you found it useful 🙂

[@rakeshricky7015]

Perfect Explanation 👏

[@learnwidgiggs]

Glad to hear this 🙂

[@user-lm5wb8vi1x]

Finished watching

[@anunaydubey7174]

Thanks for sharing this Sir❤

[@learnwidgiggs]

Welcome 🙂

[@sanjeevchaurasia1261]

Thankyou sir for sharing this valuable video. if i had to write this DAX, my approach would be this Total_Sales = VAR filter1 = FILTER( Sales , Sales[Gender] = " F " ) VAR filter2 = FILTER( Sales , Sales[State] IN { "Karnataka", "Maharastra", "Gujarat"}) RETURN CALCULATE( SUM(Sales[Amount]),filter1,filter2)

[@sonalisinghal988]

Amazing video sir🙏

[@learnwidgiggs]

Glad to hear this 🙏

[@TeluguTonicGlobal]

Greate Explanation sir

[@learnwidgiggs]

Glad you found it helpful 🙂

[@nitinsharma2019]

Also upload the dataset for practice

[@keerthiraj3498]

Tqsm bro ❤

[@learnwidgiggs]

Welcome 🙂

[@amitkumarsingh8936]

The comment section is also very informative guys

[@moodituupoo1727]

Do they keep aptitude test before technical test in MNC's?

[@NaveenKumar-gh7ks]

Hello sir , can you share about resume for freshers

[@vishalshelar4886]

Sir what mean by Freelansing work please make a video of freelancing data analytics job

[@SUEZ_EMPIRE]

Very nice

[@learnwidgiggs]

Thank you 🙏

[@kamalgopalsingh244]

We could have used visual level filter to filter condition??is it not professional way ????

[@bloggingbyasifali4984]

Hi sir can u plz make video for 3+ powerbi developer resume.

[@ArpitPawar-kk1wr]

This formula is showing error that sum cannot work with value of type string.

[@karthikrajag6796]

recent interview questions in capgimini 1) I have 4 visual and 2 slicers . How many queries will run if I refresh this 2 ) can we switch to import to DQ or DQ to import mode in middle of the developement in PBI. 3) Difference between Slicer and filter 4) I filter a value from filter pane , will it reduce the performance. 5) I have huge data like 5 gp of data, how will you handle can you answer for these also . Interview happened on 18th April 2024

[@learnwidgiggs]

Noted.

[@joydeepsen594]

Total Sales = var a = CALCULATE(SUM(Sales[Amount]),Sales[State]="Gujarat" && Sales[Gender]="F") var b = CALCULATE(SUM(Sales[Amount]),Sales[State]="Karnataka" && Sales[Gender]="F") var c= CALCULATE(SUM(Sales[Amount]),Sales[State]="Maharastra" && Sales[Gender]="F") var d=a+b+c return d

[@carcrazynishant]

🫡🙏 thank you

[@datayogi_]

Query - I think as we are using calculate, we dont need to add filter function, we state the conditions directly, pls correct me if I am wrong

[@learnwidgiggs]

But that will not be an optimized solution

[@datayogi_]

@@learnwidgiggs Okay

[@Zigzag12370]

Hi bro I am worked in other domain now I am training on power bi developer how can I get job as fresher can u suggest roadmap.

[@salmankhan-fb1fj]

don't waste time in power bi bro

[@shivshankarkumar7446]

Another approach: Total sales = SUMX( FILTER( Sales, Sales[Gender] = "F" && Sales[State] IN {"Karnataka", "Maharashtra", "Gujarat"} ), Sales[Amount] )

[@aaradhyajauhari6990]

Compute intensive

[@mohammedowais4908]

SUMX is an iterator function and the DAX will be slow in this case hence not recommended

[@vikas261196]

isn't it too easy from the interview point of view ?

[@Zigzag12370]

Hi