Calculate active customers

Question

Hi,&nbsp;For a project I am working on I need to calculate the total number of active accounts.&nbsp;&nbsp;In every row I have a start date of the account and an expire date of the account.&nbsp;&nbsp;Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Start Date &nbsp; &nbsp; &nbsp; &nbsp; End date &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1-sep &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1-okt2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 5-okt &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10-nov..&nbsp;345 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6-okt &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1-dec&nbsp;&nbsp;I would like to know how many active accounts there per month. Anyone have a suggestion how to calculate this?&nbsp;Thank you!

v-piga-msft · Answer

Hi&nbsp;raymondvz,
&nbsp;
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.
&nbsp;
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.
&nbsp;
Best Regards,
Cherry

Forum Discussion

Calculate active customers

1 Reply

Related content

Calculating active figures

Calculate Active Customers

Creating ICMs via Activator

calculate cumulative sales for active products

Fabric pipeline activities web activity Oauth error