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:
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
* Answer: CALCULATE LASTDATE * Explanation: - CALCULATE: Changes the filter context to evaluate the expression at a specific date. - LASTDATE('Date'[Date]): Ensures the calculation is done at the last date in the current filter context (end of the month, end of the year, or specific day). - Because the Date table is related to Inventory, this works seamlessly across different levels of granularity. - SUM('Inventory'[QuantityAvailable]): Aggregates the inventory quantity.
Correct answer
Hello, can someone explain to me why Max won't do (if that's the case, as it seems)? Thank you in advance!