Exam PL-300 topic 2 question 41 discussion

Actual exam question from Microsoft's PL-300

Question #: 41
Topic #: 2

DRAG DROP -
You need create a date table in Power BI that must contain 10 full calendar years, including the current year.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer

Suggested Answer:

Box 1: YEAR -
Get the current year.

Box 2: TODAY -
TODAY returns the current date.

Box 3: CALENDAR -
CALENDAR returns a table with a single column named ג€Dateג€ containing a contiguous set of dates. The range of dates is from the specified start date to the specified end date, inclusive of those two dates.
The following formula returns a table with dates between January 1st, 2005 and December 31st, 2015.
CALENDAR (
DATE ( 2005, 1, 1 ),
DATE ( 2015, 12, 31 )
Reference:
https://dax.guide/calendar/

by Namenick10 at Sept. 21, 2022, 3:11 p.m.

Comments

Submit Cancel

Namenick10

Highly Voted 2 years, 9 months ago

Year Today Calendar

upvoted 70 times

...

mahtab

Highly Voted 2 years, 8 months ago

Correct : Year Today Calendar

upvoted 13 times

...

rcaliandro

Most Recent 10 months ago

The answer is correct, YEAR - TODAY - CALENDAR is the correct sequence

upvoted 3 times

...

AyoJose

1 year, 9 months ago

But, will "-9" from today's date give a date of 10years ago?

upvoted 2 times

Helena1

1 year, 6 months ago

Yes, it does. This range included in the explanation is actually 11 years: DATE ( 2005, 1, 1 ), DATE ( 2015, 12, 31 ). So, subtracting 9 gives you 10 full years counting from the first full year till the end year.

upvoted 5 times

...

Igetmyrole

1 year, 9 months ago

Year Today Calendar Year: calculates the starting year for the date table. Today: simply assigns the current date. Calendar: is used to generate a date table. It starts from January 1st of the year and goes up to December 31st of the current year.

upvoted 9 times

...