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
