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?
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.
