Forum Discussion

Bharani308's avatar
Bharani308
Frequent Visitor
6 years ago

Help Required on Cohort Analysis Table

Hello People,   I am trying to do a cohort analysis with below data but I did not get the desired result   Student Id Application Sent Date Deposit Paid 154563 08/07/2019 17 July 20...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Bharani308 ,

 

Maybe you can modify the var:

pastCustomers =
    CALCULATETABLE (
        DISTINCT (  UnionSelectColumns[Emails]  ),
        ALL ( UnionSelectColumns[M&Y], UnionSelectColumns[M&Y No] ),
        UnionSelectColumns[Rankx] <= acquisitionMonth
    )

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.