Forum Discussion
RichOB
Post Partisan
Post PartisanCount 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]))
)
bhanu_gautam
Super User
Super UserRichOB , use
DAX
StudentsLeft =
CALCULATE(
COUNTROWS('YourTableName'),
NOT(ISBLANK('YourTableName'[Moved_On_Date]))
)