Forum Discussion
Calculating License Renewal Statistics
First time working with PowerBI/DAX -I'm sure I'm overlooking something simple, but I've messed this up a few times while following along with some similar posts so I figured it was time to reach out for some help.
I'm trying to measue how the average length that customers have had an active license has changed over time. I have about 2.5 years of data and I'd like to generate a graph to show, based on when the license started, what the averge number of days that a license remained active.
I have a single table with a customerID column, a licenseStart datetime column, and a licenseExpiration datetime column. Eventualy I'd like to split data up by an additional column "licenseType."
This seems like it should be simple but I can't seem to get it work - would anyone be able to point me in the right direction?
Thanks!
6 Replies
If you can post sample/example data that would help along with an example of what you want the result to be. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365Thanks Greg. Those links are close to what I'm looking for, but not exactly. Let me add some detail to my original post with your suggestions.
Summary:
I have a single table where each row contains a bunch of information about customers. I think the relevant columns in this calculation are the licenseStartDate, licenseEndDate, and licenceType. I'd like to create a dataset and some visuals that indicate how the length (number of days) that a customer has had an active license changed over time, on average.
Sample Data:
https://drive.google.com/file/d/1kxiZ31Ff4H6HT9y4GbJZFa2f8kzY6AX_/view?usp=sharing
Description:
ID: Unique identifier of the customer
licenseStartDate: The date that the license was activated
licenseEndDate: The date that the licenses expired/was canceled.
licenseType: Indicates what type of license this record is related to
Expected Result:
I'm attempting to generate a graph where the X axis are dates for which licenses were created and the y axis is the number of days, on average, those licenses remained active. Possibly grouping the data on the X axis into months or quarters.
Thanks for the help!
Would anyone be able to help with this additional information? I think it could be helpful to others since I couldn't find any other post directly addressing this metric. Thanks!
Hi jce0,
Could you please offer me more logic information about how to calculate "the averge number of days that a license remained active" that you want?
Regards,
Daniel He
