Forum Discussion

Andy6001's avatar
Andy6001
Frequent Visitor
7 years ago

Renewal rates

Hi, I'm trying to work out customer renewal rates, but the way in which our records are stored is making this tricky with Power BI.   Each customer has a unique User ID, but some customers will ha...
Need Help
vbisen's avatar
vbisen
Frequent Visitor
7 years ago

Hi
can you confirm if this is waht you are looking for

 

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

Andy6001 

 

Try this MEASURE

 

Measure =
VAR myusers =
    CALCULATETABLE ( VALUES ( CardTable[UserID] ), CardTable[CardStatus] = 6 )
VAR UsersInPrevMonths =
    CALCULATETABLE (
        VALUES ( CardTable[UserID] ),
        FILTER (
            ALL ( CardTable ),
            CardTable[PurchaseDate] < MIN ( CardTable[PurchaseDate] )
                && CardTable[CardStatus] = 10
        )
    )
RETURN
    DIVIDE (
        COUNTROWS ( INTERSECT ( myusers, UsersInPrevMonths ) ),
        DISTINCTCOUNT ( CardTable[UserID] )
    )