Microsoft Power BI Data Analyst — Question 112

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:

• Due Date
• Order Date
• Delivery Date

You need to support the analysis of sales over time based on all the date foreign keys.

Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.

Does this meet the goal?

Answer options

Correct answer: A

Explanation

The solution is correct because renaming the date table as Due Date allows for proper identification within the report, and creating calculated tables for Order Date and Delivery Date enables the use of all date foreign keys for analysis. Establishing active relationships between the sales table and each date table ensures that the sales data can be accurately analyzed over time based on these dates, meeting the goals of the scenario.