Self-review: Configure aggregations using DAX :Deploy and Maintain Power BI Assets and Capstone project (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

Question 1

Which DAX function was important for determining the company’s median sales?

✅ MEDIAN
❌ TOTALYTD
❌ SUM

Explanation:
The MEDIAN function is used to identify the middle value in a dataset. It helps represent typical sales performance by minimizing the impact of extremely high or low values.

Question 2

True or False: When calculating the Yearly Profit Margin for Tailwind Traders, you derived the margin by dividing the total gross revenue by the net revenue from the Sales in USD table

✅ True
❌ False

Explanation:
This statement is True. In the Tailwind Traders analysis, the Yearly Profit Margin was calculated by dividing the total gross revenue by the net revenue available in the Sales in USD table, following the methodology used in the dataset.

Question 3

Which DAX formula did you use to calculate the Year-to-Date profit?

❌ 'CalendarTable'[Date](TOTALYTD([Yearly Profit]))
❌ TOTALYTD([Yearly Profit])
✅ TOTALYTD([Yearly Profit Margin], ‘CalendarTable'[Date])

Explanation:
The TOTALYTD function requires:

1. A measure

2. A date column

The third option correctly follows the required DAX syntax by including both elements.

🧾 Summary Table