Cohort Analysis Help

[Bharani308]

@Follow the link for Files

https://drive.google.com/drive/folders/1zRC1FBn_3lUNSY5TBJueXdlfrQFnypQK

My Cohort Table:

Cohort Table

Actual Applications and Deposits

Actual Apps and Deposits

I would like to show a cohort table using the above data 

How many students applied in a specific month and out of which how many deposits happened in subsequent months.

with below approach, it is giving me the number of applications sent by students in a specific month but it's not giving me a number of deposits on the same month

Example:

In the month of July 2019, 96 applications out of which 3 deposits made in July 2019, 8 deps made on Aug2019, 5 in Sep2019, 4 in Oct2019, and 1 in December 2019.

My cohort table is showing deposits for all the months except July.

Can someone please help me with the same?

@amitchandak 

@Greg_Deckler

@v-frfei-msft 

@MFelix 

@PaulDBrown 

@Mariusz 

@Anonymous I tried following your approach posted here

[amitchandak]

@Bharani308 ,

Refer, if these can help

http://funbiworld.com/2019-12-02-cohort-analysis/

https://community.powerbi.com/t5/Desktop/Customer-cohort-analysis/td-p/87818

[Greg_Deckler]

@Bharani308 - Perhaps:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Patient-Cohort-AND-Slicer/m-p/391883#M130

Would be helpful if you posted text data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Bharani308]

If you'r asking  the data please follow this https://drive.google.com/drive/folders/1zRC1FBn_3lUNSY5TBJueXdlfrQFnypQK