Forum Discussion
ryan_b_fiting
Post Patron
Post PatronFinding the 'Current' Status based on most
Hello Community - We want to report for the last day of each historical month how many people were in each state. If that data looked like this (for a single learner): LearnerId Status ...
amitchandak
Super User
Super Userryan_b_fiting , have month year, either in your table or date table and use a measure like
lastnonblankvalue(Date[Month-Year],count(Table[Status]))
Month year = format([Date],"YYYY-MM")