You are creating a report in Power BI Desktop. You are consuming the following tables.
You have a new table named Fiscal that has the same schema as the Date table, but contains the fiscal dates of your company. You need to create a report that displays the total sales by fiscal month and calendar month.
What should you do?
A. Union Fiscal and Date as one table.
B. Add Fiscal to the model and create a one-to-many relationship by using Date[Year] and Fiscal[Year],
C. Add Fiscal to the model and create a one-to-one relationship by using Date[Year] and Fiscal[Year].
D. Merge Fiscal into the Date table.
