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 DatelD that has a Data Type of Whole Number. DatelD is in the format of YYYYMMDD.
You need to create a relationship between Date and Invoices.
What should you do first?
A. Change the Data Type of InvoiceDate and DatelD to Text
B. Create a calculated column in Invoices that uses the FORMAT DAX function
C. Change the Data Type of DatelD to Date
D. Create a measure in Invoices that uses the FORMAT DAX function
Correct is B.
Yes correct is B.
I think c is wrong answer. You cannot change whole number to date directly
Interestly that it will work if you convert to text and then convert to date.