Employee Benefits enrollments - Need something like a last non blank for every employee each month.

[Anonymous]

I have a table of employee benefit enrollments. The table has a has an employeeid, benefit enrolled, benefit enrollment start date, benefit enrollment end date (null if they are currently enrolled). I want to have a graph by month that shows the current number of employees enrolled in a benefit. My problem is that if I just do a county based of start date I only graph how many employees enrolled in a particular month, not how many are enrolled earlier and have not ended their enrollment. Is there a way to do this using DAX?

This is what I'm using to get the count of how many started their enrollment

Benefit Enrollment Count = Sum('Employee Benefit Enrollment'[Benefit Enrollment Count])

SQL Table Structure
CREATE TABLE dbo.Benefits
(
employeeid INT,
BefitCode VARCHAR(20),
BenefitStartDate DATE,
BenefitEndDate DATE
)

[Greg_Deckler · Accepted solution]

Sample data would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365