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
Step Sequence / Reordering Question
Add and arrange the steps in the correct execution order.
Hotspot Solution:
LASTDATE('Date'[Date]) returns the latest visible date in the current context (like the last day of a month). Headcount[Date] = LASTDATE(...) filters the Headcount table to only rows from that date. CALCULATE(...) applies that filter before counting rows — giving you the number of employees on the last snapshot date. This is a classic semi-additive pattern: additive across employees, but not across time.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
LASTDATE('Date'[Date]) returns the latest visible date in the current context (like the last day of a month). Headcount[Date] = LASTDATE(...) filters the Headcount table to only rows from that date. CALCULATE(...) applies that filter before counting rows — giving you the number of employees on the last snapshot date. This is a classic semi-additive pattern: additive across employees, but not across time.
CountRows("HeadCount") : return the count of employees LastDate(headcount["DateKey"]): obtain the last date available, the exercise mention you have a related date table, so, the data table is connected to Headcount table via DateKey
CountRows("HeadCount") LastDate(headcount["DateKey"]) it's literally an almost identical example in the Microsoft documentation: quote: " Example The following sample formula creates a measure that obtains the last date, for the current context, when a sale was made in the Internet sales channel. = LASTDATE('InternetSales_USD'[SaleDateKey]) " https://learn.microsoft.com/en-us/dax/lastdate-function-dax#example