Analyzing and Visualizing Data with Microsoft Excel — Question 93

You add two tables named Date and Invoices to a data model. Invoices contains a column named InvoiceDate that has a data Type of Date. Date contains a column named DateID that has a Data Type of Whole Number. DateID is in the format of YYYYMMDD.
You need to create a relationship between Date and Invoices.
What should you do first?

Answer options

• A. Change the Data Type of InvoiceDate and DateID to Text
• B. Create a calculated column in Invoices that uses the FORMAT DAX function
• C. Change the Data Type of DateID to Date
• D. Create a measure in Invoices that uses the FORMAT DAX function

Correct answer: C

Explanation

The correct answer is C because changing the Data Type of DateID to Date allows for a proper relationship between the Date and Invoices tables based on the date values. Options A and D do not address the need for compatible data types for relationships, while B suggests creating a calculated column, which is unnecessary if the data types can be aligned directly.