Microsoft
70-778 · Question #70
70-778 Question #70: Real Exam Question with Answer & Explanation
Sign in or unlock 70-778 to reveal the answer and full explanation for question #70. The question stem and answer options stay visible for context.
Question
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?
Exhibit
Options
- AUnion Fiscal and Date as one table.
- BAdd Fiscal to the model and create a one-to-many relationship by using Date[Year] and
- CAdd Fiscal to the model and create a one-to-one relationship by using Date[Year] and
- DMerge Fiscal into the Date table.
Unlock 70-778 to see the answer
You've previewed enough free 70-778 questions. Unlock 70-778 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.