Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
DavidDL
New Member

Help creating a report about license usage

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

2 REPLIES 2
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.