Posted by: Pdfprep
Post Date: November 12, 2020
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 AdivityDate is a number column named DatelD. DatelD 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 DatelD to Date.
D . Create a calculated column in ActivityLog that uses the format DAX function.
Answer: D