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
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)- A2% (1)
- B9% (4)
- C7% (3)
- D82% (37)
Community Discussion
No community discussion yet for this question.
