topic Re: DAX questions for a Test in DAX Commands and Tips

DAX questions for a Test

ogroz — Wed, 15 Jan 2025 08:07:58 GMT

Hello everyone,

I am working with a HR Dep to create a DAX and Power Query questionnaire for candidates.
They should not be too difficult or too simple.
Does anyone know a good source whith the questions examples?

Thank you

Re: DAX questions for a Test

BeaBF — Wed, 15 Jan 2025 08:16:54 GMT

ogroz Hi! This is a really good source:
50 Power BI interview questions to evaluate candidates’ skills

if it helps, please accept my answer as solution!

BBF

Re: DAX questions for a Test

Anonymous — Fri, 24 Jan 2025 02:49:45 GMT

Hi ogroz ,

Dax:

1.Can you explain the difference between a calculated column and a calculated measure in DAX? 2.How would you create a running total in Power BI using DAX? 3.Can you describe the use of the CALCULATE function in DAX? 4.How do you use time intelligence functions in DAX for year-over-year analysis? 5.Explain how you would use the FILTER function in a DAX expression. 6.What are the different types of context in DAX (row context, filter context, etc.), and why are they important? 7.Can you provide an example of how to use the RELATED function in DAX? 8.How would you handle many-to-many relationships in Power BI using DAX? 9.Explain the difference between SUMX and SUM in DAX. 10.How would you create a dynamic ranking in a Power BI report using DAX? 11.Can you describe how to use the SWITCH function in DAX? 12.What is the purpose of the ALL function in DAX, and how would you use it? 13.How do you optimize DAX queries for better performance? 14.Explain how you would write a measure to calculate the percentage of total sales in Power BI using DAX.

Power query:

1. Import data 2. Go back to the Power Query editor. 3. Switch the storage location 4. Delete blank lines 5. Delete the interval line 6. Replace multiple consecutive blank characters with one 7. Reverse the contents of the line 8. Perspective and reverse perspective 9. Create and use parameters 10. Merge and append

Best Regards

Re: DAX questions for a Test

govind_021 — Fri, 24 Jan 2025 05:00:07 GMT

Hi , ogroz
With theory questions you can also include dax questions to solve business problem
please check out some questions on this site
https://curbal.com/25-days-of-dax-fridays-challenge

Regards
Govind Sapkade ( Data Analyst , Power BI PL 300 Certified , MS Fabric Enthusiast )
Linkdin : www.linkedin.com/in/govind-sapkade-845104225
Youtube : http://www.youtube.com/@govind_dataanalyst