Exit 70-778 Analyzing and Visualizing Data with Microsoft Power BI
Question 5 of 5
0% complete
Q5 Single choice

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?

  • A

    FORMAT([Date], "MMM") & " " & FORMAT([Date], "DO") & ", " & FORMAT([Date], "YYYY")

  • B

    FORMAT([Date], "MM") & " " & FORMAT([Date], "DO") & ", " & FORMAT([Date], "YYYY")

  • C

    [Date].[Month] & " " & FORMAT([Date], "D") & ", " & [Date].[Year])

  • D

    FORMAT([Date], "MMMM DO, YYYY")

Previous Save & finish