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
Hot Area / Sentence Completion
Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.
Hotspot Solution:
Position of the second parenthesis (closin parenthesis) IN FRONT of the second argument is totally misleading; since TOTALYTD function requires two mandatory arguments, you can assume this is an error and this parenthesis should be AFTER the second argument.... TOTALYTD and Date[Date] should work in this scenario.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Position of the second parenthesis (closin parenthesis) IN FRONT of the second argument is totally misleading; since TOTALYTD function requires two mandatory arguments, you can assume this is an error and this parenthesis should be AFTER the second argument.... TOTALYTD and Date[Date] should work in this scenario.
Answer is correct TOTALYTD, 'Date'[Date]
Correct! Could Be: CALCULATE( [Total Revenue], TOTALYTD('Date'[Date]) )