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?
You Are Creatin 1 (91.92 KiB) Viewed 68 times
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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!