ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam
Go to Exam

Exam 70-778 topic 1 question 44 discussion

Actual exam question from Microsoft's 70-778
Question #: 44
Topic #: 1
[All 70-778 Questions]

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], "DD") & ", " & FORMAT([Date], "YYYY")
  • B. FORMAT([Date], "M") & " " & FORMAT([Date], "D") & ", " & [Date].[Year])
  • C. [Date].[Month] & " " & FORMAT([Date], "D") & ", " & [Date].[Year])
  • D. FORMAT([Date], "MMMM DD, YYYY")
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by kilowd at Feb. 11, 2020, 4:52 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
kilowd
Highly Voted 5 years, 2 months ago
FORMAT function using “MMM” produces the short name version of month (eg. Jan, Feb, Mar etc.). If the full month name is required, simply replace “MMM” with “MMMM”
upvoted 13 times
...
b_o_b_a
Most Recent 2 years, 9 months ago
Selected Answer: D
Definitely D - tested it using FORMAT([Date], "MMMM DD, YYYY")
upvoted 1 times
...
CDL
4 years, 6 months ago
tested, D is correct. BTW, if option A's "MMM" replaced by "MMMM" also works, tested, same result. Key point here is to show complete "month name" is "MMMM", "MMM" only showing abbreviation as "3" letters such as "Dec".
upvoted 3 times
...
Amanulla
4 years, 7 months ago
D is correct - FORMAT([Date],"MMMM DD, YYYY").
upvoted 1 times
...
Bravo2061
4 years, 7 months ago
The Answer is D. Comma is already there inside format. It's working fine as I have already tested this. You can also try.
upvoted 1 times
...
RajuM
4 years, 8 months ago
D is correct Answer
upvoted 1 times
...
JideID
4 years, 11 months ago
D is correct - FORMAT([Date],"MMMM DD, YYYY"). With the above DAX you'd get December 01,2014
upvoted 2 times
...
ahilal
5 years, 1 month ago
I think C is the right answer, "MMMM" will not result in giving me December, can someone explain please?
upvoted 1 times
ahilal
5 years, 1 month ago
mmmm Display the month as a full month name (January–December). Localized. Correct answer is D, please disregard my comment
upvoted 9 times
...
...
Echicken07
5 years, 2 months ago
D is missing a comma....The Syntax that is given will just come up with an error....FORMAT([Date], "MMMM DD, YYYY") <-- [MMMM DD is not a command].
upvoted 1 times
cromastro
4 years, 8 months ago
Wrong. D is the answer. I created a calculated column with the formula given by copy and paste. It works.
upvoted 4 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago