nerdexam
Microsoft

70-778 · Question #84

You have a Power BI model that has a date table. A sample of the data shown in the following table. You need to add a column to display the date in the format of December 01, 2014. Which DAX formula…

The correct answer is D. FORMAT([Date], "MMMM DO, YYYY"). See the full explanation below for the reasoning.

Question

You have a Power BI model that has a date table. A sample of the data shown in the following table. You need to add a column to display the date in the format of December 01, 2014. Which DAX formula should you use in Power BI Desktop?

Exhibit

70-778 question #84 exhibit

Options

  • AFORMAT([Date], "MMM") & " " & FORMAT([Date], "DO") & ", " & FORMAT([Date], "YYYY")
  • BFORMAT([Date], "MM") & " " & FORMAT([Date], "DO") & ", " & FORMAT([Date], "YYYY")
  • C[Date].[Month] & " " & FORMAT([Date], "D") & ", " & [Date].[Year])
  • DFORMAT([Date], "MMMM DO, YYYY")

How the community answered

(45 responses)
  • A
    2% (1)
  • B
    9% (4)
  • C
    7% (3)
  • D
    82% (37)

Community Discussion

No community discussion yet for this question.

Full 70-778 Practice