Forum Discussion
YoungLearning
Helper III
Helper IIIGetting help with this complicated DAX question
Can someone explain to me why CountRows since the employee name will be recorded for every month he/she stays employed, and why that filter LastDate Date?
The LASTDATE filter will adjust the filter context to only return a single date. COUNTROWS then calculates the employee count for that date (month).
YoungLearningHelper III
Helper IIIYes, seems like it. But back to the original question now. Why not the Headcount[date] column, why Date[date]? This columns have a relationship.
YoungLearningHelper III
Helper IIIIt wants to count the number of employees, year, month and quarter basis. COUNTROWS definitely double count if I do it by year or quarter.
- YoungLearning
example data