Top 10 Power BI DAX Interview Questions and Answers

[@hiteshKumar-bd7pk]

9th question & answer is best 👌. Great learning 👍

[@ankitbansal6]

Thanks! I'm glad you found it helpful.

[@mohitsharma-f2d6e]

very insightful video ankit. Thank you for coming up with this playlist on DAX

[@sivapulimamidi2]

Thank you for sharing..

[@balajithandavan6842]

Thanks bro 🎉🎉

[@Uzair_khan2890]

Hi Ankit, please create a video of theoretical Power BI Questions which are asked in the interview. Also, if possible please create a video on the data warehouses. Thanks for this video.. Doing Great. 🎉

[@vishwassharma3312]

Please upload a Play list of complete dax programming like sql play list. Easy, Medium , complex daxing. Please please

[@lets_get_creative]

For 1st que. Instead of creating sort order column in original table which is lot of duplication we can create seperate table with age group and sort order column and connect with employee table on age group column. Second approach would be avoiding age group column in employees table and using below dax to achieve employee count in age group: Calculate(countrows(employees),filter(employees,employee[age]>=agegroup[min]&&employee[age]

[@ankitbansal6]

Thanks for the alternative approach!

[@hiteshKumar-bd7pk]

I am using 1 one always 😁

[@madhusudhanreddyt2838]

For conditional formatting, it is better to create a measure like below CF_Color_IF = IF([Total Sales] > 200000, "Green", "Red") so that we can reuse the measure to apply conditional formatting for multiple areas within the reporting

[@ankitbansal6]

Thanks for sharing that approach!

[@smileymoviereview2589]

Difference between sameperiodlastyear and parallel period dax. This question asked in my interview

[@HimanshuSingh-lk2my]

Please make a comprehensive DAX and power BI course on your site

[@atulbhandvalkar2510]

Sir, you did not discuss the second question in this video.

[@ankitbansal6]

Yes I missed it. Will add in next video .

[@ankitbansal6]

Next video after 1000 likes 🎉

[@ankitasthana4895]

Thanks Ankit for sharing this, I wish I could have liked it 1000 time by myself so we can get the another video sooner😋

[@ankurprasad3737]

Sir , do we need to learn DSA for data related jobs ? Many people say companies ask dsa in college placement for data roles

[@pratiksingh07]

No

[@Ayush-i2z]

Sir I am preparing for power bi developer role as a fresh can you create hai complete dex question for the interview purpose actually as a fresher kitta dex aana chheye muje ye bhi nai alum

[@jaitiwari241]

Is alteryx better than power bi

[@AbhishekSharma-vm7tr]

Thank you sir are these questions for freshers level or experienced candidates?

[@ankitbansal6]

Up to 3 years of experience

[@AbhishekSharma-vm7tr]

@ankitbansal6 ok sir thankyou but kuch fresher ke liye bhi content bana diya karo sir

[@monish_kanna]

Hi Ankit, Thanks for the Video Correct me if am wrong, Fiscal year should be from current year april month to next year march month right? but in above approach, won't it take jan,feb and march from the same year? (which is supposed to be the part of previous fiscal year) Am little confused on that part alone!

[@ankitbansal6]

If we put year in the visual then it will look fine

[@Einaressence]

You need to create fiscal year column first from the date column defining fiscal year based on the fiscal year used in that company for some it starts from September for some April and so on. Once you have created that then you can do rest shown in this video

[@kajoripaul7279]

If you can give the pbix file for this one, that would be great.Thank you!!

[@madhusudhanreddyt2838]

Dynamic Title..if multiple years are selected the logic doesn't work. we need to use the below dax for multiple year selections in the slicer Dynamic Title_1 = VAR _yearList = CONCATENATEX(VALUES('Calendar'[Year]), 'Calendar'[Year], ", ", 'Calendar'[Year], ASC) RETURN IF(ISFILTERED('Calendar'[Year]), "Category Wise Total Sales For " & _yearList, "Please Select Year")