Aspiring participants before taking the Microsoft DA-100 real exam,
Need to learn a variety of exam study materials.
But our experts say that candidates should try to obtain validated preparation materials for the DA-100 exam, https://www.pass4itsure.com/da-100.html which may help pass the exam.
Latest Microsoft DA-100 practice test
QUESTION 1
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”) and “” and FORMAT(\\’Date\\'[year], “#”)
D. FORMAT(\\’Date\\’ [date_id], “MMM YYYY”)
Correct Answer: D
Scenario: In the Date table, the date_id column has a format of yyyymmdd. Users must be able to see the month in
reports as shown in the following example: Feb 2020.