Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Cohort Analysis tutorial

Dear,  I am new to Power BI.  Could you please to provide me the tutorial of how to build Cohort Analsysis in Power BI? I used to make CA in Tableau, and now my job requires me to build CA in Powe...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    You can download my pbix from the following link

     

    https://we.tl/t-hQF2IvvDGd

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dear, 

Thank you for your solution 

I applied you formular in my company data

I got an error of QuarterNo for my Customer1stPurchase

I assumed that because of the date format. When I adjusted Date Format in C2C1stpurchase column, it changed to different result. 

 

when I changed to Date format

I just tried the formular on sample_superstore; it gives the same error. 

Did you tried it on data sample_superstore? If yes, Could you share me your file please? 
Hope you help me to fix it!!

Thanks 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

You can download my pbix from the following link

 

https://we.tl/t-hQF2IvvDGd

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Dear, 

    Once again, thank you so much for spending time helping me!

    I can solve it right now! 

    Many thanks and really appreciated

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi, 

    One more thing. 

    Could you please to explain me at this point
    VAR MF = (OrderYear - BaseYear)*4

     

    Hope to hear from you!!

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Quarter No will always get only values between 1 to 4. But we want to ignore the years and have a running quarter no.

       

      For example, if 2014 January is Q1, then we want 2016 January as Q9 and not as Q1 again.

      So we calculate the difference between 2016 and 2014, i.e. 2016-2014 = 2

       

      MF = (2016-2014) = 2 * 4 = 8

      For 2016 January, the quarter no will be calculated by default as Q1. Instead, we add MF (value 8) to Q1 and get the result as Q9.

       

      Hope it clarifies.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Dear, 

        Thank you for your clear explanation. 

        I understand it. 

        Could you please explain what is the different between Order's Quarter No and Customer's Q00?

        Because I saw you make a calculation of like this: 

        ReturningQuarterNo =
"Q"
    & FORMAT ( Orders[OrderQtrNo] - Orders[CustomerQ0], "00" )

         

        I dont know what is the differeces and why we have to minus it. 

        Hope you could clarify!!

        Thanks 

  • hastinfatah's avatar
    hastinfatah
    New Member
    6 years ago

    HI sreenathv

     

    I new in power bi, and I have to built cohort graph. When I see this post, I am verry happy because you provide .pbix file. But the lini was expired.

    Could you sent new link of .pbix cohort file, please ?

     

    Thanks and Regards