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: A
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.