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. Add the Weekly_Returns data to the Sales table by using RELATED DAX functions.
B. 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.
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.
