Percentage growth based on accumulated

[Anonymous]

Helo!
I have a table with the customer's ID and the date of their first purchase. For example:

Client ID	First Purchase
1000	12/01/2020
1001	13/01/2020
1002	01/03/2020
1003	06/08/2021
1004	13/01/2020
1005	06/08/2021

I created a formula to calculate the cumulative number of new customers in my base:

Accumulated customers = CALCULATE([Cliente Summary],filter(all('Summary Clients'),'Summary Clientes'[First Purchase]<=max('Summary Clientes'[First Purchase])))

However, I, not able to create a formula that will bring me the percentage growth between one date (in this case, month) and another..

How can I do this?

Tks in advance!

[amitchandak · Accepted solution]

@Anonymous ,

Accumulated customers till date = CALCULATE([Cliente Summary],filter(all('Summary Clients'),'Summary Clientes'[First Purchase]<=max('Summary Clientes'[First Purchase])))

A month back = CALCULATE([Cliente Summary],filter(all('Summary Clients'),'Summary Clientes'[First Purchase]<=eomonth(max('Summary Clientes'[First Purchase]),0)))

or

Accumulated customers till date = CALCULATE([Cliente Summary],filter(all('Summary Clients'),'Summary Clientes'[First Purchase]<=maxX('Summary Clientes',dateadd('Summary Clientes'[First Purchase],-1,month))))

But prefer date table in case of last option

[Anonymous]

Hi!

The second formula (A month back ) worked when I changed 0 for -1.

Tks a lot!