Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Namenick10
Highly Voted 2 years, 1 month ago
Year Today Calendar
upvoted 66 times
...
mahtab
Highly Voted 2 years ago
Correct : Year Today Calendar
upvoted 12 times
...
rcaliandro
Most Recent 2 months ago
The answer is correct, YEAR - TODAY - CALENDAR is the correct sequence
upvoted 2 times
...
AyoJose
1 year, 1 month ago
But, will "-9" from today's date give a date of 10years ago?
upvoted 2 times
Helena1
10 months, 3 weeks 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, 1 month 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 8 times
...
rgabage
1 year, 1 month ago
Year Today Calendar
upvoted 1 times
...
EwoutBI
1 year, 2 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, 1 month 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, 4 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, 4 months ago
was this in the learning paths? how do you find the answer for this
upvoted 3 times
...
Sandy2010
1 year, 6 months ago
The answer is correct
upvoted 1 times
...
RazaTheLegend
1 year, 6 months ago
Correct, it is Year Today Calendar
upvoted 1 times
...
svg10gh
1 year, 9 months ago
Correct ans: Year Today Calendar
upvoted 1 times
...
Patrick666
1 year, 10 months ago
Year Today Calendar
upvoted 2 times
...
samad1234
2 years ago
The answer is correct
upvoted 4 times
...
lukelin08
2 years ago
Answer is correct
upvoted 5 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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