jce0 Tracker

Re: Calculating License Renewal Statistics

jce0 — Tue, 30 Oct 2018 15:33:50 GMT

The number of days that a license remains active should just be (licenseEndDate) - (licenseStartDate) providing the number of days that a single license was active. I was then hoping to put that information into buckets (I was thinking by the year and month of the licenseStartDate) to examine how the length that licenses remained active changed over time.

Let me know if that provides enough info.

Thanks Daniel!

Re: Calculating License Renewal Statistics

jce0 — Tue, 30 Oct 2018 16:30:37 GMT

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!

Re: Calculating License Renewal Statistics

jce0 — Fri, 26 Oct 2018 20:02:44 GMT

Thanks 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!

Calculating License Renewal Statistics

jce0 — Fri, 26 Oct 2018 16:55:42 GMT

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!