Help creating a report about license usage

[DavidDL]

Hi all,

I'm trying to make a report. In the data I have a collection of license usages. In the report I would like to see how much licenses are active during an amount of time (hour, day). I want to know at peak moments how much licenses are in use. 

Thanks in advance

Kind regards

David

[amitchandak]

@DavidDL , if you have range, start, and end date, you need have approach like

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

the same need to be extended to hours using time table

[DavidDL]

Thanks a lot for the quick reply I will check this out.