Forum Discussion

Cobra77's avatar
Cobra77
Post Patron
7 years ago

How calculate Client returning by month ?

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 [email protected] 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

Need Help
Show and Tell

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Cobra77
      Post Patron
      7 years ago

      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's avatar
        Anonymous
        Not applicable
        7 years ago

        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