Calculate Retain Customer

[atul9063]

Hi,

I want help in calculating retained users :

Output 

month	Count of retain Users
Jan	4
Feb	2
Mar	3

Dataset 

Date	Useritemid
1/1/2018	1
1/2/2018	2
1/3/2018	3
1/4/2018	6
2/10/2018	1
2/11/2018	3
2/12/2018	10
2/13/2018	3
2/14/2018	1
2/15/2018	11
3/15/2018	1
3/16/2018	2
3/17/2018	3
3/18/2018	10
3/19/2018	14

[Zubair_Muhammad]

@atul9063

try this

Create a calendar table and then this MEASURE

Measure =
VAR PreviousMonthUsers =
    CALCULATETABLE (
        DISTINCT ( Table1[Useritemid ] ),
        PREVIOUSMONTH ( Table1[Date] )
    )
VAR CurrentMonthUsers =
    DISTINCT ( Table1[Useritemid ] )
RETURN
    IF (
        ISEMPTY ( PreviousMonthUsers ),
        COUNTROWS ( CurrentMonthUsers ),
        COUNTROWS ( INTERSECT ( PreviousMonthUsers, CurrentMonthUsers ) )
    )

[Zubair_Muhammad · Accepted solution]

@atul9063

See file attached as well

[atul9063]

@Zubair_MuhammadThanks for quick response