Which DAX expression should you use?

Posted by: Pdfprep Category: DA-100 Tags: , ,

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.

Leave a Reply

Your email address will not be published.