Forum Discussion

jce0's avatar
jce0
Regular Visitor
7 years ago

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...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

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

jce0's avatar
jce0
Regular Visitor
7 years ago

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!

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi jce0,

    Based on my test, you could refer to below formula:

    Days = DATEDIFF('Table1'[licenseStartDate],'Table1'[licenseExpirationDate],DAY)

    And you could use the [licenseStartDate] as x-axis and use the Days as value to create a visual:

    You could also download the pbix file to have a view.

     

    Regards,

    Daniel He