How calculate Client returning by month ?

[Cobra77]

Hi ,

How calculate Client returning by month ?

Sample : ( left table, all data )

I want calculate number of users active in the month that were also active in the preceding month
In july ,I must have just 1  , only toto@test.com ordered in june
the goal is to create the middle graph

How do the join on the email on the previous month ?

thanks for your helps

[Anonymous]

Hi @Cobra77 ,

How do you make the right table, I think if you have that table you can do the chart using the value of last month > 0.

If you don't have table, I think if you can change your query, you can try to left join the table using the month = month - 1 and name = name to get the last month value.

Please try.

Aiolos Zhao

[Cobra77]

Hi  @Anonymous 
the right table : with measures
Nb Montant = SUM(Table1[Montant])
Nb Previous Month = CALCULATE([Nb Montant];PREVIOUSMONTH('Calendar'[Date]))
MM = IF ([Nb Previous Month] >0 ;DISTINCTCOUNTNOBLANK( Table1[Email]); BLANK() )
 
Its MM that I searched optimize and good result in the graphic middle
 
thanks

[Anonymous]

Hi @Cobra77 ,

I think your way is a good method to finish the middle chart,

for now I can't find a better way to solve that...

Aiolos Zhao

[Cobra77]

Hi @Anonymous 

How can you do a join on the same table ?

on email = email and MONTH = previousMONTH ?

Thanks

[Anonymous]

Hi @Cobra77 ,

Yes, that's what I thought.

Aiolos Zhao