What should you do first?

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 which Number. DateID 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 DateID to Text.
B . Create a measure in Invoices that uses the Format DAX Function.
C . Change the Data Type of DateID to Date.
D . Create a calculated column in Invoices that uses the Format DAX function.

View Answer

Answer: D