https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Active-Client-Count/m-p/316985#M156483 <P>Attempting to do an active client count. An active client is a client that has an end date greater than the current date and a start date prior&nbsp;to the current date. Our current active client count as of 12/1 is 4,362 clients. This number differs slightly on a month to month basis (clients added vs. clients dropped). I've been tasked with finding what the active client count is from month to month, going back 5 years. I am confused as to how to put this together in Power BI to show graphically and what formulas I need to use. Ideally on one graph, I would like to have one line showing the # of clients added each month, and another line showing for the month what the new total active employee count is/was. Example:<BR /><BR />October '17: 67 Clients Added, 15 Clients Dropped,&nbsp;Total Employee Count = 4,362</P><P>September '17:&nbsp;38 Clients Added, 10 Clients Dropped,&nbsp;Total Employee Count = 4,353</P><P>etc.<BR />etc.<BR /><BR />How can one achieve this in Power BI? Can provide more info/background if needed.</P> Mon, 04 Dec 2017 21:27:38 GMT Anonymous 2017-12-04T21:27:38Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Active-Client-Count/m-p/316985#M156483 <P>Attempting to do an active client count. An active client is a client that has an end date greater than the current date and a start date prior&nbsp;to the current date. Our current active client count as of 12/1 is 4,362 clients. This number differs slightly on a month to month basis (clients added vs. clients dropped). I've been tasked with finding what the active client count is from month to month, going back 5 years. I am confused as to how to put this together in Power BI to show graphically and what formulas I need to use. Ideally on one graph, I would like to have one line showing the # of clients added each month, and another line showing for the month what the new total active employee count is/was. Example:<BR /><BR />October '17: 67 Clients Added, 15 Clients Dropped,&nbsp;Total Employee Count = 4,362</P><P>September '17:&nbsp;38 Clients Added, 10 Clients Dropped,&nbsp;Total Employee Count = 4,353</P><P>etc.<BR />etc.<BR /><BR />How can one achieve this in Power BI? Can provide more info/background if needed.</P> Mon, 04 Dec 2017 21:27:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Active-Client-Count/m-p/316985#M156483 Anonymous 2017-12-04T21:27:38Z