nerdexam
Microsoft

70-779 · Question #27

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…

The correct answer is C. Change the Data Type of DateID to Date. https://support.office.com/en-us/article/data-types-in-data-models-e2388f62-6122-4e2b-bcad- 053e3da9ba90?ui=en-US&rs=en-US&ad=US#__toc319430522

Model data by using Microsoft Excel

Question

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?

Options

  • AChange the Data Type of InvoiceDate and DateID to Text.
  • BCreate a measure in Invoices that uses the Format DAX Function.
  • CChange the Data Type of DateID to Date.
  • DCreate a calculated column in Invoices that uses the Format DAX function.

How the community answered

(19 responses)
  • A
    16% (3)
  • B
    5% (1)
  • C
    74% (14)
  • D
    5% (1)

Explanation

https://support.office.com/en-us/article/data-types-in-data-models-e2388f62-6122-4e2b-bcad- 053e3da9ba90?ui=en-US&rs=en-US&ad=US#__toc319430522

Topics

#table relationships#data types#Power Pivot#date tables

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-779 Practice