Analyzing and Visualizing Data with Microsoft Power BI — Question 74

You plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart.
The date value in ActivityDate is a number column named DateID. DateID is in the YYYYMMDD format.
What should you do in the model before you create the relationship?

Answer options

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

Correct answer: D

Explanation

Creating a calculated column in ActivityLog that uses the FORMAT DAX function is necessary to convert the datetime format of ActivityStart to match the YYYYMMDD format of DateID. The other options do not effectively resolve the datatype mismatch, as changing the type of ActivityStart or DateID would not align them correctly for the relationship.