Exam PL-300 topic 2 question 78 discussion

LASTNONBLANK doesn't work as it requires 2 inputs LastDate('headcount'[datekey])/ FirstDate('headcount'[datekey]) doesn't work simply because firstdate and lastdate requires a date. Datekey is not a date Therefore, Lastdate('date'[date]) is correct

CountRows("HeadCount") LastDate(headcount["DateKey"]) Why? The first to count the number of employes The second because if we use lastDate over Date it will retrieve always the 31 december 2030 (It says that in date table are present dates from 2020 to 2030) So the result will always be the same. But if we take the lastDate in the DateKey we'll have the first day of the month and year of the last snapshot. Am i correct?

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

EmployeeCount = CALCULATE( APPROXIMATEDISTINCTCOUNT(Headcount[EmployeeID]), LASTDATE('Date'[Date]) )

The answer seems correct.

There is no much upvotes.Feels like everyone in tired of solving these questions.

Table Headcount will contain “one row per employee for each month the employee is employed”. As I understand it, if we run the newly created measure for quarter or year, then the table will contain multiple rows of the same employee, given that the employee was employed the whole time. Therefore using CountRows(‘’Headcount) would retrieve 3 or 12 for each employee being present in the whole period, which seems problematic as he is only one person. On the other hand, ApproximateDistinctCount will count an instance of that same employee only once, since the function aggregates on the passed column (key) before counting. Correct me if I am wrong, but I think the correct answer should be ApproximateDistinctCount and LastDate(‘Date’[Date]) Reference: https://learn.microsoft.com/en-us/dax/approximate-distinctcount-function-dax

CALCULATE( COUNTROWS('Headcount'), LASTNONBLANK('Headcount'[Date]) ) The problem is the table "Headcount"'s date key is the first day of each month. LASTDATE('DATE'[DATE]) returns the last day of the selected period, which filters out the value in the "Headcount" table.

Chat GTP LastDateHeadcount := VAR LastDate = MAXX( FILTER( ALL('Date'[Date]), 'Date'[Date] <= MAX('Date'[Date]) && 'Date'[Year] = MAX('Date'[Year]) ), 'Date'[Date] ) RETURN CALCULATE( COUNTROWS('Headcount'), 'Headcount'[DateKey] = LastDate ) So Chat GTP also suggest: CountRows("HeadCount") LastDate(headcount["DateKey"])

CORRECT

while the input is the first day of month, but the request is the last date. How can we set the filter as lastdate? i testes but it gave blank()