Which DAX expression should you use?

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

Answer: D

Explanation:

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.

Latest DA-100 Dumps Valid Version with 114 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments