Microsoft Certified: Power BI Data Analyst Associate PL-300 Question # 7 Topic 1 Discussion
PL-300 Exam Topic 1 Question 7 Discussion:
Question #: 7
Topic #: 1
You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?
A.
In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.
B.
Add the Weekly_Returns data to the Sales table by using related DAX functions.
C.
Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.
Scenario: Region managers require a visual to analyze weekly sales and returns.
To relate the two tables we need a common column.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit