Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Drag & Drop Scenario
Read the scenario requirements and decide your answer. Click Check Answer below to see the marked solution.
Hotspot Solution:
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.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
The answer is correct, YEAR - TODAY - CALENDAR is the correct sequence
But, will "-9" from today's date give a date of 10years 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.