Forum Discussion
Solved
Count measure by end_date
Hi, I have student accommodation and need to count the number of students who have left a location based on their end date. What measure would show this figure as 5, please? Location Stude...
RichOB , use
DAX
StudentsLeft =
CALCULATE(
COUNTROWS('YourTableName'),
NOT(ISBLANK('YourTableName'[Moved_On_Date]))
)
Hi RichOB
You can use the same approach
StudentsLeftCount =
CALCULATE(
COUNTROWS('YourTableName'), //
NOT(ISBLANK('YourTableName'[Moved_On_Date]))
)