Create user retention chart on daily basis

[dengydongn]

Trying to create a user retention rate chart, input would be userid/date, and output would be given a certain date, how much percentage of user returned on a future date up to today, see below sample, I dont really have a clue, so any pointers are appreciated.

input

user_id	date
a	5/1/2020
a	5/2/2020
a	5/3/2020
b	5/1/2020
c	5/1/2020
c	5/2/2020
d	5/1/2020
e	5/1/2020
f	5/1/2020
g	5/1/2020

output

	5/2/2020	5/3/2020	5/4/2020	5/5/2020	5/6/2020	5/7/2020
5/1/2020	10%	8%	7%	12%	9%	8%
5/2/2020		4%	5%	20%	3%	4%
5/3/2020			6%	6%	6%	6%
5/4/2020				6%	6%	6%
5/5/2020					6%	6%
5/6/2020						6%

5/7/2020 is the max date from input table (or just today to make it simpler). The table is read as 10% distinct users who visited my website on 5/1 returned on 5/2.

[v-easonf-msft]

Hi , @dengydongn 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
More people will learn new things here. If you haven't, please feel free to ask.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@dengydongn , Very similar to cohort Analysis, refer if these can help

https://finance-bi.com/power-bi-cohort-analysis/

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