Calculate active customers

[raymondvz]

Hi,

For a project I am working on I need to calculate the total number of active accounts. 

In every row I have a start date of the account and an expire date of the account. 

Name           Start Date         End date         

1                    1-sep                 1-okt

2                    5-okt                 10-nov

..

345                 6-okt                 1-dec

I would like to know how many active accounts there per month. Anyone have a suggestion how to calculate this?

Thank you!

[v-piga-msft]

Hi @raymondvz,

I'm not clear what's your logic to calculate the active customers, but you could have a reference of this similar thread first which has been solved with Dax and M query.

If you still need help, please share your data sample as table and your desired output so that I can understand your requirement better and get the solution.

Best Regards,

Cherry