1. Which DAX function would you use to calculate the year-to-date sales for the current year in Power BI?

2. You want to compare sales for the first quarter of this year to the same period last year. Which function should you use?

3. What is essential to have in your Power BI model to properly use DAX time intelligence functions like TOTALYTD?

4. How would you calculate the running total of sales month-to-date in Power BI using DAX?

5. When using DAX time intelligence, what is the role of the DATESYTD function?

6. How can you handle a fiscal year that doesn’t start in January using DAX time intelligence?

7. What function allows you to return the same date last year, useful for creating year-over-year comparisons?

8. Which DAX function would you use to return a table with dates for the current month in Power BI?

9. If you need to calculate the total sales for the last full year, which DAX function would be most appropriate?

10. What is a common mistake when using DAX time intelligence functions in Power BI?