Power bi - User retention rate calculation

Question

I am using Power Bi and searched and the forums and couldn't find anything similar to what I am using

So, I had a table that looks like this

I have used the following measures

RetentionRate = (ReturningUsers / PreviousDayDistinctUsers)*100%

ReturningUsers = DistinctUsers - NewUsers

PreviousDayDistinctUsers = CALCULATE(DISTINCTCOUNT(table[User], PREVIOUSDAY(table[Date])

NewUsers = CALCULATE(DISTINCTCOUNT(table[User] ), table[MonthlyNewUsers] = BLANK () )

 

Answer 1

Use the following measures

PreviousDayDistinctUsers =
   VAR Current_Day = LASTDATE ( table[Date] )
   RETURN 
    CALCULATE ( DISTINCTCOUNT ( table[User] ), table[Date] < Current_Day ) 

Do you wish to learn Power BI? Do check out how you can become a Power BI Developer from this blog.

Get an introduction to Power Bi by checking out the following youtube link: 

 

Want to earn a certificate in Power BI? here is the Power BI Course that will make you industry ready.