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
Andy6001's avatar
Andy6001
Frequent Visitor
7 years ago

Hi vbisen,

 

That is exactly the output I'm looking for. 

If you could share how you got from your inital MEasure to there it would be greatly appreciated!

 

Thanks,

 

Andy

vbisen's avatar
vbisen
Frequent Visitor
7 years ago

Hi Andy

Great.

Here are the steps i followed:

1. Create a New Table (Date) based on available dates in CardTable

Date = CALENDAR(MIN(CardTable[PurchaseDate]), MAX(CardTable[ExpiryDate]))
2. Define relationship between CardTable and Date table based on CardTable.PurchaseDate and Date.Date columns
3. Create following Measure in Date table
Measure4 =
CALCULATE(COUNT(CardTable[UserID]), CardTable[CardStatus] <> 10)/CALCULATE(count(CardTable[UserID]))
 
Hope this will solve your issue.