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 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.
YoungLearningHelper III
Helper IIIexample data