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

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam
Go to Exam

Exam DA-100 topic 6 question 1 discussion

Actual exam question from Microsoft's DA-100
Question #: 1
Topic #: 6
[All DA-100 Questions]

You need to create a calculated column to display the month based on the reporting requirements.
Which DAX expression should you use?

  • A. FORMAT('Date'[date], "MMM YYYY")
  • B. FORMAT('Date' [date], "M YY")
  • C. FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")
  • D. FORMAT('Date' [date_id], "MMM YYYY")
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by GopalBhau at May 19, 2022, 9:49 p.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
GopalBhau
Highly Voted 3 years, 2 months ago
Selected Answer: A
Wrong; date_id isn't date type
upvoted 14 times
...
alenashkel_
Most Recent 2 years, 9 months ago
I cannot see the image
upvoted 1 times
...
Tomaszthomas
2 years, 9 months ago
I checked. If date_id has a format of "yyyymmdd" then the FORMAT from date_id with "MMM YYYY" is not working
upvoted 2 times
...
svw2020
2 years, 11 months ago
Selected Answer: D
If the date id is 43831 -format(date(dateid),"mmm yyyy") will give Jan 2020.
upvoted 1 times
...
QWERTYman
3 years ago
Selected Answer: A
Answer is A if there was date column, picture is not shown anymore.
upvoted 1 times
...
Matreshka
3 years, 1 month ago
Selected Answer: A
There is Date column. And its format is Date. See the pic of tables and columns
upvoted 1 times
...
anurag49
3 years, 1 month ago
Answer is A
upvoted 1 times
...
Kancha02
3 years, 1 month ago
Selected Answer: D
The answer should be D because the question does not mention the column name 'Date' in the Date table therefore instead of assumption we should use the information in question that is the date_id column in the yyyymmdd format
upvoted 4 times
...
KRM_Will_444
3 years, 1 month ago
Selected Answer: A
The answer is "A" because the data type for column "date_id' is "integer". Whereas, the data type for column "date" is "Date".
upvoted 2 times
...
yl_leslie
3 years, 1 month ago
It should be A, since you will get error when you try to format date_id
upvoted 2 times
...
Yakaa
3 years, 2 months ago
Selected Answer: D
Date_id is the column
upvoted 2 times
...
claudeaboki
3 years, 2 months ago
there is no date column but date_id so D is correct
upvoted 3 times
...
Mona00
3 years, 2 months ago
Selected Answer: D
D is correct the reasons as follow 1. users must be able to see the month in reports as shown in the following example: Feb 2020. 2 it doesn't exist "date" column in the date table.
upvoted 3 times
...
Mad0701
3 years, 2 months ago
Selected Answer: D
D is correct
upvoted 2 times
...
Mad0701
3 years, 2 months ago
Selected Answer: D
D is correct answer.
upvoted 2 times
...
Fofo97
3 years, 2 months ago
I am agree with the answer, D is the best choise!
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