Lost Users

[beaoliv123-_]

Hi,

I am calculating the lost users using the following formula:

Lost Users =

CALCULATE(

DISTINCTCOUNT(table[user_id] ), DATESBETWEEN('Slicer'[Date], MIN('For Slicer'[Date])-365, min('Slicer'[Date])-90),

FILTER(

SELECTCOLUMNS(

FILTER( ALL( table)table[date] < MIN('For Slicer'[Date])),

"@user_id", table[user_id]

),

NOT [@user_id] IN VALUES( table[user_id])

),

ALL()

)

And the output is this:

What is happening is that this is cumulative and I just wanted to know how many users were lost each day, instead of a specific day to the past.

Do you know how do a fix this?

Thanks

[amitchandak]

@beaoliv123-_ , refer my blog for that

Customer Retention Part 5: LTD Vs Period Retention
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-5-LTD-and-PeriodYoY-Retentio...

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...