1) In a financial dashboard, you need to calculate year-over-year growth in revenue. However, some months have missing data. Which DAX function would help to address this issue by including a default value for missing months?
2) A customer satisfaction dashboard needs to display the average rating per month for each product. However, the data often has null values for certain months. How would you handle these nulls to avoid impacting the average calculation?
3) In a report for tracking employee time, you need to display the number of hours worked by department, with a focus on employees who worked overtime. How would you calculate the total overtime hours for each department?
4) You are creating a customer dashboard for a loyalty program, which tracks points earned and redeemed. You need to calculate the net points balance for each customer. Which approach is most efficient?
5) For a project management report, you need to display only the top 3 highest-priority tasks in each project. Task priority is defined in a priority column. What approach would best accomplish this?
6) In a financial report, you are asked to calculate a rolling 12-month revenue total. Which DAX function or approach would best accomplish this?
7) In a sales performance report, you need to calculate the number of distinct customers who made purchases each quarter. Which DAX function would you use?
8) For a logistics report, you need to analyze average shipping time by region. The dataset includes order date, ship date, and region. How would you calculate the average shipping time for each region?
9) You are working on a Power BI report that tracks customer acquisition costs (CAC) over time. The data includes marketing expenses and new customers acquired each month. How would you calculate the monthly CAC?
10) In a product sales report, the client wants to see the total sales contribution of each product relative to the overall sales. Which DAX function would you use to create this measure?
11) You need to create a trend analysis report that displays total monthly sales as a cumulative value, restarting each year. What DAX function would achieve this?
12) In an HR analytics report, you are asked to calculate the average tenure of employees by department. The dataset includes each employee’s start and end date. Which DAX formula is most appropriate?
13) You are building a dashboard that needs to highlight the top 10 products contributing the most revenue. How would you apply this in Power BI?
14) A financial report requires showing cumulative sales for each quarter but resets at the end of each fiscal year. How would you set this up?
15) You need to calculate the Year-to-Date (YTD) revenue for each region in a sales dashboard. What approach would best capture this information?
16) In a customer analysis report, you need to calculate the retention rate, defined as the percentage of returning customers. What steps would you take to calculate this?
17) For a productivity report, you need to create a measure showing the percentage of tasks completed on time by each team. The dataset includes task start date, due date, and completion date. Which DAX function setup would you use?
18) You are creating a sales performance dashboard and need to track quarterly growth as a percentage compared to the previous quarter. Which DAX function would you apply for this?
19) In a Power BI report for monitoring subscription-based services, you need to calculate the churn rate (percentage of customers who unsubscribed each month). What approach would best fit?
20) You’re analyzing profitability by product line, and the data includes costs, sales, and returns. Which measure would you create to display the net profit margin for each product line?
