Forum Discussion

MichielvS's avatar
MichielvS
Frequent Visitor
9 years ago
Solved

calculation

[ Spoiler ] I want to calculate the average churn, based upon two tables in my model, containing:     Table1 Clientnr          Month         Subscription A                     201501        1 ...
Need Help
Show and Tell
Tips and Tricks
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi MichielvS,

    Based on my understanding, for 201501 month, there is 2=1+1(AandB) Churn in Table2, 2=1+1(AandB) Subcription in table1, so 100%=2/2. And for 201502 month, there is 0=0+0(A and B) Churn in Table2, 2=1+1(A and B) Subcription in Table1, so 0%=0/2, right? If it is, please review the following steps.

    First, click New table under Modeling in home page, create two new tables using the following formulas.

    Table11 = SUMMARIZE(Table1,Table1[Month],"count",SUM(Table1[Subscription]))

    Table22 = SUMMARIZE(Table2,Table2[Month],"count",SUM(Table2[Churn]))

     

    Please see the new tables.

     

     


    Then create relationship between Table11 and Table22.



    In table22, create a calculated column using the formula, create a table visual to show the expected result.

    Chrun% = Table22[count]/RELATED(Table11[count])





    If this is not what you want, please let me know.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi MichielvS,

Based on your description, it's difficult to reproduce the scenario. Unusualy there is one question in one case. I personally suggest you open a new thread and post the sample data and expexted result. Thanks for your understanding.

Best Regards,
Angelia

MichielvS's avatar
MichielvS
Frequent Visitor
9 years ago

I will do that, thanks.