Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 6 question 1 discussion

Actual exam question from Microsoft's DA-100

Question #: 1
Topic #: 6

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

Suggested Answer: A 🗳️

by GopalBhau at May 19, 2022, 9:49 p.m.

Comments

Submit Cancel

GopalBhau

Highly Voted 3 years, 1 month ago

Selected Answer: A

Wrong; date_id isn't date type

upvoted 14 times

...

alenashkel_

Most Recent 2 years, 7 months ago

I cannot see the image

upvoted 1 times

...

Tomaszthomas

2 years, 7 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, 10 months ago

Selected Answer: D

If the date id is 43831 -format(date(dateid),"mmm yyyy") will give Jan 2020.

upvoted 1 times

...

QWERTYman

2 years, 10 months ago

Selected Answer: A

Answer is A if there was date column, picture is not shown anymore.

upvoted 1 times

...

Matreshka

2 years, 11 months ago

Selected Answer: A

There is Date column. And its format is Date. See the pic of tables and columns

upvoted 1 times

...

anurag49

2 years, 11 months ago

Answer is A

upvoted 1 times

...

Kancha02

2 years, 12 months 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

2 years, 12 months 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 ago

It should be A, since you will get error when you try to format date_id

upvoted 2 times

...

Yakaa

3 years ago

Selected Answer: D

Date_id is the column

upvoted 2 times

...

claudeaboki

3 years ago

there is no date column but date_id so D is correct

upvoted 3 times

...

Mona00

3 years 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

...