ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 41 discussion

Actual exam question from Microsoft's PL-300
Question #: 41
Topic #: 2
[All PL-300 Questions]

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Namenick10
Highly Voted 2 years, 3 months ago
Year Today Calendar
upvoted 67 times
...
mahtab
Highly Voted 2 years, 3 months ago
Correct : Year Today Calendar
upvoted 12 times
...
rcaliandro
Most Recent 4 months, 3 weeks ago
The answer is correct, YEAR - TODAY - CALENDAR is the correct sequence
upvoted 3 times
...
AyoJose
1 year, 3 months ago
But, will "-9" from today's date give a date of 10years ago?
upvoted 2 times
Helena1
1 year, 1 month 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, 4 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
...
rgabage
1 year, 4 months ago
Year Today Calendar
upvoted 1 times
...
EwoutBI
1 year, 4 months ago
There is a typo in this exercise, the right code is: Date = var var1 = YEAR(TODAY()) RETURN CALENDAR( DATE(var1, -9, 01), DATE(var1, 12, 31))
upvoted 1 times
discoverp
1 year, 4 months ago
There is no typo here. The DATE(var1 -9, 01,01) is meant to subtract 9 from the value of var1 which in turn is a YEAR value of TODAY()'s date.
upvoted 4 times
...
...
vat4444
1 year, 7 months ago
Answer given is correct Date = var var1 = YEAR(TODAY()) return CALENDAR(DATE(var1 - 9,01,01), DATE(var1,12,31) )
upvoted 4 times
...
nmnm22
1 year, 7 months ago
was this in the learning paths? how do you find the answer for this
upvoted 3 times
...
Sandy2010
1 year, 8 months ago
The answer is correct
upvoted 1 times
...
RazaTheLegend
1 year, 9 months ago
Correct, it is Year Today Calendar
upvoted 1 times
...
svg10gh
2 years ago
Correct ans: Year Today Calendar
upvoted 1 times
...
Patrick666
2 years, 1 month ago
Year Today Calendar
upvoted 2 times
...
samad1234
2 years, 2 months ago
The answer is correct
upvoted 4 times
...
lukelin08
2 years, 3 months ago
Answer is correct
upvoted 5 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago