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”)