From a list of subscription records with ending subscription dates, I’ve created a measure to compute “Days To Renewal Due Date” for each subscription at any given date.
- Customer ID
Days To Renewal Due Date =
I would now like to group the number of subscriptions by the “Days till Renewal Date” into groupings of “1-30days”, “31-60days”, “61-90days”, “>90 days”.
As the “Days till Renewal Date” is itself a Measure, Power BI somehow doesn’t allow me to create another measure to count the number of subscriptions for each specific “Days till Renewal Date” to answer the simple question – “How Many Subscriptions Are Due for Renewal in X Days?”
Appreciate the community’s and Sam’s help on this please…